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 |
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
 Posted - 2011-09-07 : 06:34:40
|
| We rebuilded DNS but all windows authentication sid changed. This logins are map with sql now I am not able to login using windows authentication. So I droped windows logins from sql and remaped but One user account I am not able to drop from sql( I revoked all permission and all schemas map to diff user).When I checked in sys.server_principals table the old user account sid is '0x010500000000000515000000D2A563D563017ECB11074B9DF4010000'but my new user accountsid is '0x010500000000000515000000675B42E76628F5A49166717E58040000'now i want to update this Id in my sql table sys.server_principals(I have enabled sp_configure 'allow updates',1 and tried to update but its not working any solution )In Love... With Me! |
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2011-09-07 : 15:23:09
|
| Can you post the failure messages/errors?Steve |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-07 : 21:38:24
|
| Either the user owns something, or potentially, you have corruption -- which wouldn't be a huge surprise of you're routinely modifying system tables. |
|
|
|
|
|
|
User Not able to drop