Posts Tagged ‘SQL Logins’
Orphaned User After Migration To SQL 2005
Monday, February 25, 2008
Leave a comment
After migrate SQL 2000 to SQL 2005 the SQL-Logins lost the relationship (Database <-> Server).
To fix the problem:
Find the SQL-Logins which orphaned: Exec sp_change_users_login ‘Report’
Run following statement to resolve the problem: Exec sp_change_users_login ‘UpdateOne’, ‘Name’, ‘Name’
Note: This will only work for SQL-Logins.
There is a parameter “Auto_Fix“ available. I don’t use it due to security reasons.
Categories: Administration, Troubleshooting
Migration, Orphaned, SQL Logins, Users