Dynamics CRM 2011 Installation Error The instance name must be the same as computer name

When install Dynamics CRM 2011 Server, you may come across this error on System Checks screen; it is related to Microsoft SQL Server and the information is “The instance name must be the same as computer name.”.

This can happen if you rename the database server computer name after you have installed SQL Server.

1. figure out what is saved in SQL Server:

select @@servername

SP_HELPSERVER


2. figure out the database computer name, Start -> Computer -> Properties

3. drop invalid computer name saved in SQL Server

SP_DROPSERVER "INVALID SERVER NAME"

4. add correct computer name to SQL Server

SP_ADDSERVER "CORRECT SERVER NAME", local

5. restart the MSSQLSERVER service

Advertisements

5 comments on “Dynamics CRM 2011 Installation Error The instance name must be the same as computer name

  1. Pingback: Action Microsoft.Crm.Setup.Server.AddServerAction failed. Exceeded column length: Column Name - Pablo Peralta's Blog

  2. Pingback: Action Microsoft.Crm.Setup.Server.AddServerAction failed. Exceeded column length: Column Name - Pablo Peralta’s blog - CRM Technical Blogs - Microsoft Dynamics Community

  3. Thanks for the post for posting “Dynamics CRM 2011 Installation Error The instance name must be the same
    as computer name | Zhongchen Zhou’s Blog”. I actuallywill absolutely be back for a great deal more reading and writing comments soon enough. Many thanks, Dylan

  4. Pingback: SQL Server instance name must be the same as computer name | CRM-Konsulterna

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