Saturday, November 20, 2010

The instance name must be the same as computer name

CRM 2011 Install - System Checks - Verification Description and Results: Microsoft SQL Server - 'The instance name must be the same as computer name'.

Resolution:
Open Microsoft SQL Server Management Studio
Step 1:
SELECT @@SERVERNAME AS 'Old Server Name', SERVERPROPERTY('Servername') As 'Current Server Name'
Step 2:
exec sp_dropserver 'AAAA(The old server name)'
GO
sp_addserver 'BBBB(The current server name)', local
GO
Step 3: Restart SQL Server service

No comments:

Post a Comment