Microsoft KB Archive/921971

= Error message when you try to install Microsoft Dynamics CRM 3.0 on a computer that is running a named instance of SQL Server: &quot;MachineName value \ is invalid&quot; =

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:

&quot;MachineName value \  is invalid&quot;

Note The  placeholder is a placeholder for the name of the computer that is running SQL Server. The  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:

http://support.microsoft.com/default.aspx?scid=fh;[LN;CNTACTMS]



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:
 * 1) On the computer that is running SQL Server, click Start, click All Programs, click Microsoft SQL Server, and then click Enterprise Manager.
 * 2) 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.
 * 3) 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 &quot;How to add the NT Authority\Network Service account&quot; section.
 * 1) 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 &quot;Databases and roles&quot; 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:
 * 1) 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.
 * 2) Right-click Logins, and then click New Login.
 * 3) Type NT Authority\Network Service, and then click OK.
 * 4) Click the Database Access tab, and then grant the correct permissions for the correct databases, as shown in the table in the &quot;Databases and roles&quot; section.

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.