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 |
|
brinster
Starting Member
8 Posts |
 Posted - 2006-01-06 : 12:52:46
|
| HiWe have on sqlserver 7 ;We have the problem of Orphaned users with GROUPSQL (domain\user) ; i try to user sp_change_users_login 'Update_one','domain\user' ,'bd' and for sqlserver user doesn t exist ;yet in syslogin view there is a loginname with domain\user and also in sysuser view Regards |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-06 : 13:18:17
|
| I don't think I have ever heard of this problem with Windows Authenticated accounts, as the SIDs for those are generated by the DC (I think), rather than SQL Server. What are the SIDs for this user in master..syslogins and db..sysusers? |
 |
|
|
|
|
|
Orphaned users