Missing Users, yet they exist!

[JennyPeters]

Hi,

I'm running SQL7 and seem to have a problem with missing users in the Users view of my DB. I know the users exist, as they use their NT windows login as authentication, and if I try to add them, a message appears stating they already exist. Yet, they are not seen in the view, nor in the user views of any other DB's.

Any thoughts?

Jenny

 

[nigelrivett]

Are they local admins? If so they will be connecting as sa if you haven't removed the role.

Another possibility is that the database has lost the login/user mapping.

look at the sid for the login in master..syslogins and see what that sid refers to in db..sysusers.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.