Orphaned SQL Server Users
Monday, July 16th, 2007 by GarrettMoving databases from one server to another running MS SQL Server can result in orphaned database users. This is because the database user isn’t properly mapped to the SQL server login on the new server. Surprisingly, the only way to fix this is by running a stored procedure called sp_change_users_login. Hopefully you’re aware of [...]
Read More...