October 25, 2005 at 1:40 pm
Hello,
We installed a COTS product that created a database in SQL Server 2000 SP3a as part of its installation process. When we went to examine what it did we found two logins that were created for the application and given roles in the new database.
The strange thing is that when using the Enterprise Manager and viewing the logins in the Security, Logins page the logins show that they do not have any role in the new database. If we try to assign a role it says the login already has the role. Refreshing does not update the data. When viewing the users in the database sysmembers and sysusers the memberuid and groupuid rows are there and correct.
If we create another new blank database and create the logins manually there are no anomolies.
Has anyone seen this before, or know how a role can be assigned to a login at the database level but not show up in the Login, Security page?
Regards,
Brent
October 25, 2005 at 1:56 pm
What shows up in the databases Users view in EM?
Name filled in, but Login Name blank?
If so the sid in sysusers does not match the sid in master..sysxlogins.
Fix this by running sp_change_users_login, see the BOL.
Norman
October 25, 2005 at 2:09 pm
The login seemed okay in the database users view in EM. The login was there and not blank. We could use the accounts and everything seemed to work okay, except for the Security - Logins view.
Brent
October 26, 2005 at 8:05 am
Hmmm. Sorry, I'm stumped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply