How To Re-Associate An Orphaned SQL User With A SQL Login
Read Time:25 Sec
I ran across an issue the other day when making a mirror of the Production environment. The problem was that after doing a database backup on one SQL Server and then restoring that backup to another SQL Server there were SQL Users that were in the database but not on the SQL Server instance.
Luckily, I found a post on Sean Decker – SQL Fundamentals, that explains exactly how to fix it with a simple SQL statement:
EXEC sp_change_users_login 'UPDATE_ONE', 'sqlusername', 'sqlloginname'
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating