Wednesday, February 24, 2010

CRM Install Problem: instance name must be the same as computer name

Open a query window in the Microsoft SQL Server Management Studio and run the following command.  It will display to you the current name of the SQL server.

sp_helpserver
GO

Next we will run the following commands.  Replace old_name with the SQL server name you discovered in the sp_helpserver command, and replace new_name with the name of the server.  (include the single quotes our the names)

sp_dropserver 'old_name'
GO
sp_addserver 'new_name', local
GO

Open the SQL Server Configuration Manager and resart the SQL Services.

To deteremine if the update was successful run the following command against the 'master' database.  If the query displays the new_name you assigned to SQL it will be displayed here.  If there is nothing displayed then something went wrong.
SELECT @@SERVERNAME