CRM 2011 – MSCRM_CONFIG database is unavailable!

[tweetmeme source=”BenHosk” only_single=false]

I recently had a very unusual error on the CRM installation.

For some reason the MSCRM_CONFIG database is suddenly entered an odd state where it can no longer be opened in SQL Manager or any applications, without this CRM won’t work (the database is where all the CRM configurations are held)

this is part of the error

Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
Login failed for user ‘DOMAIN\IISADMIN’.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
Login failed for user ‘DOMAIN\IISADMIN’.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot open database “MSCRM_CONFIG” requested by the login. The login failed.
Login failed for user ‘DOMAIN\IISADMIN’.]

here is a picture of a similar error

This error was very odd because I couldn’t think of what could have caused it.  When I tried to view the MSCRM_CONFIG database you couldn’t do anything with the database.

Googling the problem didn’t show many solutions but these two gave me the most hope and they are the same solution, I prefer the second one because it has pictures and is written by a user rather than a support document

http://support.microsoft.com/kb/946286

this is the most straight forward explanation
http://crmhacks.blogspot.com/2008/04/mscrm4-diagnostic-cannot-open-database.html

 

The solution in the end was to add the computer into SQLAccessGroup, the below solution is from here

Method 2

Add the Microsoft Dynamics CRM server to the SQLAccessGroup group in Active Directory. To do this, follow these steps:

  1. Click Start, click Run, type dsa.msc, and then click OK.
  2. Click the organizational unit in which you install Microsoft Dynamics CRM.
  3. Double-click SQLAccessGroup.
  4. In the SQLAccessGroup dialog box, click Members, click Add, click Object Types, click to select theComputers check box, and then click OK.
  5. In the Enter the object names to select box, type the name of the Microsoft Dynamics CRM server, and then click Check Names.
  6. Verify that the name of the Microsoft Dynamics CRM server in the Enter the object names to selectbox is available, and then click OK two times.
  7. Restart the Microsoft Dynamics CRM server.

 

I did these changes and nothing had happened and it wasn’t until I restarted the CRM Server machine and then the database started working again.

The unusual thing I noticed was there was two SQLAccessGroup‘s and I do remember there being an MSCRM_CONFIG database already there before I installed CRM.  I wasn’t sure if this was created by a failed install I tried (but failed on the checks) but thinking back this surely can’t have been the case.

It seems to me like CRM might have been installed on the server or maybe CRM had been installed on another server within the domain, this would explain the two SQLAccessGroups (with different guids).

 

Advertisements

4 thoughts on “CRM 2011 – MSCRM_CONFIG database is unavailable!

  1. wulkanizator December 7, 2013 / 3:23 am

    Hey there, You have done a great job. I will certainly digg it and personally recommend to my friends.
    I am sure they’ll be benefited from this site.

    Like

  2. www.mojduniya.com January 17, 2014 / 10:49 am

    Thanks for every other great post. Where else may just anybody get that
    type of info in such an ideal way of writing? I have a presentation subsequent week, and I’m on the search for
    such info.

    Like

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