Live Chat Software by Kayako |
Knowledgebase: MSSQL Server
Recovering Orphaned Database Users
Posted by on 25 August 2012 10:23 PM
|
|
Often, when restoring a database from a remote machine on my local development machine, my user logins no longer work for that database. The problem lies with the fact that while the user name is the same from machine to machine, the underlying GUID that SQL uses to identify users is different. Thankfully, there is a very easy one line command that fixes these "orphaned" users.
| |
|
Comments (0)