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.
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