Dynamics CRM 2011 Installation Error The instance name must be the same as computer name

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