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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Manually sych for server logins

Author  Topic 

DJ1975
Starting Member

1 Post

Posted - 2007-10-09 : 16:33:13
The subject is probably not new, however I am (to SQL).

I recently refreshed the test DB with production DB, now the passwords are messed up.

There is an SQL program that I ran however it failed because I had already changed the Server name back to test prior to runing the fix.

My question? Can anyone explain a manual way to sync these, there are probably six of them.

Kristen
Test

22859 Posts

Posted - 2007-10-09 : 16:39:10
May be too late, but in case not:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Fix+Orphaned+Users
Go to Top of Page
   

- Advertisement -