Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

When installing Microsoft Dynamics CRM you may receive the following error: "The Kerberos subsystem encountered an error, The SQL Server instance name must be the same as the computer name"


View products that this article applies to.

Symptom

When installing Microsoft Dynamics CRM 2011 Server, the following error may occur:

 "The SQL Server instance name must be the same as the computer name."

↑ Back to the top


Cause

The Microsoft SQL Server machine name has been changed after the Microsoft SQL Server had been installed  

↑ Back to the top


Resolution

Utilize the steps below to resolve the error message:

1. On the Microsoft SQL server, select Start and open SQL Server Management Studio

2. Connect to the Server and instance that will contain the Microsoft Dynamics CRM databases.

3. Select New Query from the toolbar

4. Enter the two lines below and then select the execute button on the toolbar

Select @@SERVERNAME

Select * from sysservers

5. Observing the results will show a mismatch.

6. Clear the previous lines and enter the line below. You will need to replace the <servername> with the name in the svrname column from step 4.

sp_dropserver '<servername>'

7. Clear the previous line and enter the line below. You will need to replace the <servername> with the value of the select @@servername from step 4

sp_addserver '<servername>', 'local'

8. Enter the two lines below and then select the execute button on the toolbar

sp_helpserver

select @@servername

9. Last Restart the SQL Server Service for this instance of SQL.


↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2841195
Revision : 1
Created on : 1/7/2017
Published on : 6/7/2013
Exists online : False
Views : 149