Friday, August 3, 2012

Change SQL Instance name to reinstall CRM 2011

I was in middle of the installation and system was throwing exception that instance name must be same as of machine name. so I had to update the instance name of SQL server. following is a script I found online and it was really helpful.

USE master

---- Fetch the SQL Server instance name - fetch the value of "name" from the output

-- Drop the old server registration
sp_dropserver 'WIN2K8\SQL2K12','droplogins'

-- Register the new server with the new name
sp_addserver 'CONTOSSSO\SQL2K12',local

No comments: