Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2002-09-23 : 15:51:16
|
| So I've been lucky enuff to get the Spida Worm, and ive gotten rid of it, but when I go to change the SA password I get the following error:"Error 21756: [SQL-DOM] 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"Anyone have any clue? Iv'e been searching and haven't found a thing.Thanks!I've already tried:EXEC sp_change_users_login 'auto_fix', 'sa'GO |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-23 : 15:54:43
|
| try:sp_changedbowner 'sa' -Chad |
 |
|
|
interclubs
Yak Posting Veteran
63 Posts |
Posted - 2002-09-23 : 17:37:09
|
| Yeah, didn't work. Can't change owner of Master DB. Thanks though. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-23 : 18:10:10
|
| Try running sp_change_users_login 'report' for every database. If one of them returns dbo, run sp_changedbowner 'sa' in that DB.-Chad |
|
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
Spida Worm and SA Login