changing sa - error 21776

[markSaunders]

Hi all,

I am attempting to change the SA password using Enterprise Manager on SQL2000.

I right-click the SA login and select properties, at this point I get the following message before I get the SA properties.

Error 21776:[SQL-DMO]The name 'dbo' was not found in the Users collection. If the name is a qualified name, use [] to seperate various parts of the name, and try again.

Any ideas what this is as I am, obviously, reluctant to make changes once the properties do actually appear.

Cheers
Mark Mark Saunders

 

[bperry]

I found this problem report for you at the MS site. Sure seems to be what you got.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q218172

What do you think?

 

[markSaunders]

Just the ticket was a missing login for one of the DBO's. Well spotted and thanks very much indeed.! Mark Saunders