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

When the Sql server instance is differ from the machine name, this error will be given as a result of verification tasks under the system check of CRM installation. Most of the time this happens if the Sql server instance changes after the first installation and reinstallations.

CRM Installation Sql Error
CRM Installation Error

Anyhow this can be fixed easily as we can use few sql stored procedures. Follow the steps listed below.

1. Open Sql Server Management Studio, get a new query window and execute “SP_HELPSERVER”. This will show the different names of Sql Instance and the Machine.
2. Execute SP_DROPSERVER [SEVER NAME] — “name” column from the result of SP_HELPSERVER execution
3. Execute SP_ADDSERVER [SEVER NAME], local — “computer_name”\”network_name” column from the result of SP_HELPSERVER execution
4. Execute SP_HELPSERVER to check whether the two names are identical
5. Restart the MSSQLServer Services, and recheck the conditions.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s