When install Dynamics CRM 2011 Server, you may come across this error on System Checks screen; it is related to Microsoft SQL Server and the information is “The instance name must be the same as computer name.”.

This can happen if you rename the database server computer name after you have installed SQL Server.

1. figure out what is saved in SQL Server:

select @@servername


SP_HELPSERVER

2. figure out the database computer name, Start -> Computer -> Properties

3. drop invalid computer name saved in SQL Server

SP_DROPSERVER "INVALID SERVER NAME"

4. add correct computer name to SQL Server

SP_ADDSERVER "CORRECT SERVER NAME", local

5. restart the MSSQLSERVER service
Filed under: Microsoft Dynamics CRM Tagged: Microsoft Dynamics CRM