CRM 2011 Installation Error: SQL instance name must be the same as computer name

This error is common when the SQL instance name is different the computer name.


Open SQL management studio, and issue an SP_HELPSERVER. This will return the current SQL instance name which is most likely different than the machine name. Verify the correct machine, by right clicking on computer, properties and looking under Computer Name, Domain and Work Group Settings. Computer name is the name you need to match.

Now issue SP_DROPSERVER “SERVER NAME” – Server name being the name from the SP_HELPSERVER command.

Next, issue SP_ADDSERVER “SERVER NAME”, local – Server name being the comtpuer name from computer settings.

Next, issue SP_HELPSERVER to see the name is now correct.

Finally, restart the SQL Services for MSSQLServer. Now go back to the CRM install, and recheck the condition!