CRM 2011: The server principal "user" is not able to access the database "CRM_DB" under the current security context

Today we have tried to restore a copy of our Production CRM into a standalone server and do some testing with the real data when we've recieved the following error:

The server principal "Crmuser" is not able to access the database "CRM_db" under the current security context.

The problem is the users being imported are not completely mapped with the users we have created in our TEST env.

Here is how to fix the problem:

Run the following in Sql server selecting the database you have just imported:


sp_change_users_login @Action='Report';

SELECT sid FROM sys.sysusers WHERE name = 'Crmuser'

SELECT sid FROM sys.syslogins WHERE name = 'Crmuser'

EXEC sp_change_users_login @Action='update_one', @UserNamePattern='crmuser',@LoginName='crmuser';


Particularly we had "crmuser" the user for accessign some "custom forms" as well and this mapping error killed me partially today, but with the bove code we can remap any CRM user and consolidate it with any imported CRM database.