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

Advertisements

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

  1. Matthew says:

    Thnaks for that, it solved our problem.

  2. Hey! Someone in my Myspace group shared this
    site with us so I came to take a look. I’m definitely enjoying the information.
    I’m bookmarking and will be tweeting this to my followers!

    Outstanding blog and fantastic style and design.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s