Article ID: 921971
Article Last Modified on 2/8/2007
APPLIES TO
- Microsoft Dynamics CRM 3.0
SYMPTOMS
When you try to install Microsoft Dynamics CRM 3.0 on a computer that is running a named instance of Microsoft SQL Server, you receive the following error message in the Environment Diagnostics Wizard:
Note The server_name
placeholder is a placeholder for the name of the computer that is running SQL Server. The instance_name
placeholder is a placeholder for the name of the instance of SQL Server.
RESOLUTION
To resolve this problem, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and for information about support costs, visit the following Microsoft Web site:
MORE INFORMATION
Verify that the NT Authority\Network Service account has the correct access
In Microsoft Windows Server 2003 and in Microsoft Small Business Server 2003 environments, you must verify that the NT Authority\Network Service account has the correct access to the Microsoft CRM and SQL Server Reporting Services databases after you install Microsoft CRM. To do this, follow these steps:
- On the computer that is running SQL Server, click Start, click All Programs, click Microsoft SQL Server, and then click Enterprise Manager.
- Expand Microsoft SQL Server, expand SQL Server Group, expand the name of the computer that is running SQL Server, expand Security, and then click Logins.
- Right-click NT Authority\Network Service, and then click Properties.
Note If the NT Authority\Network Service account is not listed as a login, you must add the NT Authority\Network Service account. For more information, see the "How to add the NT Authority\Network Service account" section.
- Click the Database Access tab, and then verify that the account has the correct permissions for the correct databases, as shown in the table in the "Databases and roles" section.
How to add the NT Authority\Network Service account
If the NT Authority\Network Service account is not listed as a login, follow these steps to add the account:
- Expand Microsoft SQL Server, expand SQL Server Group, expand the name of the computer that is running SQL Server, expand Security, and then click Logins.
- Right-click Logins, and then click New Login.
- Type NT Authority\Network Service, and then click OK.
- Click the Database Access tab, and then grant the correct permissions for the correct databases, as shown in the table in the "Databases and roles" section.
Databases and roles
Database | Roles |
---|---|
Company_Name _MSCRM
|
public and db_owner |
Company_Name _Metabase
|
public and db_owner |
ReportServer | public and RSExecRole |
ReportServerTempdb | public and RSExecRole |
master | public and RSExecRole |
msdb | public and RSExecRole |
Support for named instances of SQL Server
When Microsoft CRM 3.0 was released, we did not support installing the Microsoft CRM databases on a computer that is running a named instance of SQL Server. After the release, additional testing was performed. Therefore, we now support installing Microsoft CRM on a computer that is running a named instance of SQL Server.
Additional query words: EDW SRS SSRS
Keywords: kbtshoot kbmbsinstallation kberrmsg KB921971