CRM 2011 Server installation issue - "The instance name must be the same as computer name"

  • Article

When installing the CRM 2011 server component, you might face an error during the environment diagnostic check, regarding the SQL Server Reporting Services. You might face the blow error message:

image

"The instance name must be the same as computer name."

The environment diagnostic check (that is part of the CRM 2011 Server Setup) performs a query against the server names binded to the SQL server instance.
In case there is an inconsistence you will not be able to continue the CRM Server setup.

This issue might occur

  • If you have renamed the machine
  • Performed any binding changes after the SQL server installation

Potential resolution
To fix the issue you need to ensure that the query "SELECT @@ Servername" returns at least the machine name. f the select statement doesn't return the actual name of the machine you might consider the following steps:

to query the binds

SELECT @@ Servername

to drop the invalid name

Sp_dropserver 'OLD_SERVERNAME'

to add the correct machine name

Sp_addserver 'ACTUAL_MACHINE_NAME',local 

After you applied the changes, make sure to restart the SQL server instance and to re-run the CRM environment diagnostic check to proceed with the CRM 2011 Server setup.  

Related content
https://msdn.microsoft.com/en-us/library/ms187944.aspx
https://msdn.microsoft.com/en-us/library/ms174310.aspx
https://msdn.microsoft.com/en-us/library/ms174411.aspx

Greetings from the CRM team