November 26, 2002 at 4:32 pm
Hello everyone. My manager, who is a member of the Administrators on our database, cannot see a lot of the users in the database. He also cannot see most of the logins. I can see the users and logins, but he only sees a few. Just wanted to know why is that and if it is normal or if it is an indication of something being wrong. Thanks.
November 26, 2002 at 5:08 pm
What do you mean see? in SP_WHO? Enterprise Manager?
Steve Jones
November 26, 2002 at 6:45 pm
In EM.
November 26, 2002 at 7:03 pm
Have you recently Service Packed the server. I remember running into this once before and I beleive it had to do with a problem of the Client and the Service Pack added to the server. If nothing else run the latest Service Pack on his machine to update hist client and see what happens.
November 26, 2002 at 7:47 pm
The server has been patched a long time ago, but the client has not been.
I restored the database this weekend and this seems to be the only thing that might have caused this. I was not able to recover the master database (to a fresh sql server database), so I had to restore all other databases and add the users, linked servers, etc. manually. Could this have anything to do with the problem?
November 26, 2002 at 8:10 pm
You may have orphaned the users and for some reason are able to see them. Try sp_change_users_login with the auto_fix option to see if will correct, may be just that simple. Read the details in SQL BOL.
November 29, 2002 at 7:19 am
Maybe you have a common trouble when you restore a database, try whit this:
use master
go
exec sp_configure 'allow updates','1'
go
reconfigure with override
go
Use <db with lost users>
update u
set u.sid = l.sid
from sysusers u
inner join master..syslogins l on l.name = u.name
use master
go
exec sp_configure 'allow updates','0'
go
reconfigure with override
go
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply