After restoring a database, you may need to fix up the user login mapping (since the database is moving to a different instance of SQL Server)
EXEC sp_change_users_login 'Report'
EXEC sp_change_users_login 'Auto_Fix', 'licensing'
EXEC sp_change_users_login 'Report'
EXEC sp_change_users_login 'Auto_Fix', 'licensing'
where licensing is the user login name
Comments
Post a Comment