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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-22 : 09:07:10
|
| Sherry writes "The windows 2000 domain account that was an SA was deleted and recreated by the NT login Gods in their infinite wisdom. Now, SQL server shows that this NT login is still a member of the sa role, BUT, it can't perform SA functions. I think it is because the SIDs are out of whack. Is there an easy, safe way to resync these? Thanks for your help." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-22 : 20:33:20
|
| IF your problem actually is SIDs out of sync, then this script: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12615[/url] can fix that. |
 |
|
|
|
|
|
Windows NT SID reassigned