How to Fix a SQL and Computer Name Mismatch
Have you ever had a problem connecting to a SQL Server instance or even the default instance? There could be a very simple answer to a problem that lies deep beneath the covers that may not be readily apparent.
I ran into this scenario trying to install CRM 3.0 on a fresh install of SQL Server 2005. During the installation I was confronted with a nasty error that CRM could not connect to the SQL Server. I also was presented with another issue regarding SQL replication with a similar error about connecting to the SQL Server.
The root cause in both instances was a SQL Server and machine name mismatch. In the first scenario the machine had been renamed and the second scenario was created using a VPC image that was renamed. Looks like SQL holds onto the original name even if it is changed before SQL is installed.
How do I fix it? It is really simple!
From the Start Menu
Right click my computer, select properties and then the computer name tab and verify the machine name.
In SQL enterprise manager or sql studio open the query analyzer
Execute this command select @@servername this will return what SQL has for the machine name. If it does not match run the following commands:
EXEC sp_dropserver ''
go
EXEC sp_addserver '', 'local'
go
Reboot the server and you should be golden!
Wes Porter
Galatians 2:20
It is Jesus who I give all glory and honor, for He has provided me with all that I am and all that I have!
Here is my personal blog site at http://www.theobjectivetruth.com