Friday, March 6, 2015

The instance name must be the same as computer name. MS CRM 2011, 2013, 2015 Installation Error

Hi ,

while doing one installation(actually copied one instance of CRM VM), I found the below error...
"The instance name must be the same as computer name."
this means the instance name as per the server is not correct.
what I did was, I have taken image of my SQL VM, so the name in sql is still the old name.

Solution
go to the SQL server and open SQL management studio, connect to the SQL instance
then run the below query..

SP_HELPSERVER :this will give you the server and instance details, here I got the old one and the name does not match you VM name. keep the name and use this in next query
SP_DROPSERVER "<name got in prev query" : this will drop that value
SP_ADDSERVER "<new server name/instance name", local: this will set the current server name and instance
then should be fine.

NOTE: you might have to restart the SQL service , also bring back the CRM installer till 1st screen and then click next next next next... :P
this should work....

Regards,
Yes.Sudhanshu