Fixed – “Unable to access the MSCRM_CONFIG database. SQL Server does not exist or access denied” in CRM 2011

Hi ,

I faced an issue today when I tried to open the Deployment manager.

Below is the screenshot of the error message:

Following are the steps to resolve the issue:

  • Step 1 :
    • Goto Administrative Tools> Active Directory Users and Computers
    • Add user to the SQLAccessGroup.

  • Step 2 :
    • Goto Microsoft Dynamics CRM 2011 > Deployment Manager .
    • Add the user to Deployment Administrators

  • Step 3 :

    • Goto MS Sql Server > Security >Login >Add new login
    • Click on General give the login name and Default Database
    • In the Server Roles ,select the below roles shown:
    • Click on UserMapping and select the checkbox as shown below :

  • Step 4 :
    • Goto MSCRM_CONFIG database > Security > Users
    • Add the user with the following role memberships:

Hope it helps!

Happy ExploringJ