CRM 2011 Server installation issue - "The instance name must be the same as computer name"
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:
"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
Comments
Anonymous
December 09, 2013
This would seem to rule out doing an install against an SQL 2012 Availability Group.Anonymous
May 16, 2014
I'm trying to a CRM 2011 install on SQL Server 2012 and I get this message, but the name already matches the server name (Select @@Servername). Still won't let me install. How do I correct this?Anonymous
August 20, 2014
This resolved the problem - many thanksAnonymous
December 07, 2014
Thanks so much, great response to an issue I had, helped tremendously.