Microsoft Dynamics CRM 2011 Server installation – “The instance name must be the same as computer name”

Recently I have come across an issue “The instance name must be the same as computer name” while Microsoft Dynamics CRM 2011 performs a system check during installation.

Image

During diagnostic check CRM performs a query against the server bound to the SQL server instance and throws an exception if there are any inconsistencies.

The reason was that I setup a virtual machine using a VHD preloaded with Windows Server 2008 R2 and SQL Server 2008 R2 installation and rename the server afterwards. The SQL server is still bound to the server name which does not exist any more.

To correct this issue follow these very simple steps.

– execute built-in stored procedure “sp_helpserver” (this will return the server names bound to the current instance of SQL server and your machine should not be listed in the results.)

– To change information you have to first drop the server name that doesn’t exist anymore by executing stored procedure as sp_dropserver ‘OLD_SERVERNAME’

– then add a new entry with current server name by running the procedure as sp_addserver ‘CURRENTNAME’, ‘LOCAL’

– restart SQL server service

– reinstall CRM and you are good to go

– if you have come across this issue the same way as I did then you may come across similar issue with Reporting server too that prevents CRM installation “Setup failed to validate specified Reporting Services Report Server”. The solution is discussed here

Advertisements
This entry was posted in Microsoft Dynamics CRM, SQL Server. Bookmark the permalink.

One Response to Microsoft Dynamics CRM 2011 Server installation – “The instance name must be the same as computer name”

  1. Pingback: Microsoft Dynamics CRM 2011 Server installation – Setup failed to validate specified Reporting Services Report Server | Ali's Blog

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