Article ID: 946286 - Last Review: January 27, 2011 - Revision: 2.1

Error message when you try to log on to Microsoft Dynamics CRM: "Cannot open database '[Organization]_MSCRM' requested by the login"

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

SYMPTOMS

You install Microsoft Dynamics CRM. When you try to log on to Microsoft Dynamics CRM, you receive the following error message:

Cannot open database "Organization_MSCRM" requested by the login.
The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

If the DevErrors value is set to On in the Web.config file, you receive an error message that resembles the following:

Server Error in '/' Application.

Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
Login failed for user 'Domain\CRMServer$'.
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\CRMServer$'.

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\CRMServer$'.]

System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Microsoft.Crm.CrmDbConnection.Open() +386

Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize) +125

Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadCacheFromDatabase(CrmDBConnectionType connectionType, String connectionString) +65
Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache() +41
Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache() +114

Microsoft.Crm.ConfigurationDatabase.ConfigurationDatabaseService.InitializeMetadataCache() +28
Microsoft.Crm.SharedDatabase.DatabaseService.Initialize(String tableName) +53
Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions) +109
Microsoft.Crm.ServerLocatorService.GetSiteSettingIdFromDatabase() +155
Microsoft.Crm.ServerLocatorService.GetSiteSettingId() +187
Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName) +82
Microsoft.Crm.LocatorService.GetSiteSetting(String settingName) +35
Microsoft.Crm.CrmTrace.get_RefreshTrace() +654

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Back to the top

CAUSE

This problem occurs if one or more of the following conditions are true:

You install Microsoft Dynamics CRM in a multiple-server environment. Then, you install Microsoft Dynamics CRM directly on a server that is running Microsoft SQL Server. However, some SQL Server permissions are not set.
The Microsoft Dynamics CRM server is not added to the SQLAccessGroup group in the Active Directory directory service.

Back to the top

RESOLUTION

To resolve this problem, use one or more of the following methods.

Back to the top

Method 1

Set up the NT AUTHORITY\NETWORK SERVICE account as a SQL Server user who has access to the Microsoft Dynamics CRM databases. To do this, follow these steps:

Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Management Studio. NOTE For Dynamics CRM 2011 it will be Microsoft SQL Server 2008
To log on to SQL Server Management Studio, click OK.
In Object Explorer, expand Databases, expand the Organization_MSCRM database, and then expand Security.
Right-click Users, and then click New User.
In the Database User – New dialog box, type NT AUTHORITY\NETWORK SERVICE in the following fields:
- The User name field
- The Login name field
In the Database role membership area, click to select the db_owner check box, and then click OK.

Back to the top

Method 2

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

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