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 |
|
mufasa
Yak Posting Veteran
62 Posts |
 Posted - 2004-01-07 : 16:18:23
|
I am all of a sudden getting this error when I try to change or add permissions on existing users, except myself.When I create a new user there is not a problem.This only happens remotely, but not when I am physically on the server.The full error reads'Error 21776:[SQL-DMO]The name 'existing.user' 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.'I tried deleting the user and recreating the login, but still get the same error message.Thanks for any helpMufasa  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 17:05:06
|
| This error will only happen in Enterprise Manager. There are a couple of MS Q articles related to the error. I went through them and they refer to changing the database owner to a user that exists. Go to support.microsoft.com and type in 21776. Go through the articles and find the one that fits your environment.Tara |
 |
|
|
mufasa
Yak Posting Veteran
62 Posts |
Posted - 2004-01-08 : 08:51:28
|
| Thanks TaraWill check it outMufasa |
|
|
|
mufasa
Yak Posting Veteran
62 Posts |
Posted - 2004-01-08 : 09:54:53
|
| Well I checked it out and ran thissp_change_users_login 'Auto_Fix, 'dbo'The result were zero changes, but it did seem to fix the problems.I now have to verify that users did not get more permissions than allowed.This all happened because one of our programers restored the master database on the server.I was surprised because he is running another instance(on the same server).Well everything is back to normal I hope.Mufasa |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-08 : 12:18:36
|
| sp_change_users_login just fixes orphaned users. It does not add permissions, subtract permissions, or anything else. So you can do the check, but you don't need to.Tara |
|
|
|
|
|
|
error 21776