How to Fix a SQL and Computer Name Mismatch

Wes Porter — Thu, 27 Jul 2006 06:30:00 GMT

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 ''

EXEC sp_addserver '', 'local'

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

Introduction - How to Enable HTTPS on a SharePoint Server

Wes Porter — Wed, 30 Nov 2005 01:35:00 GMT

Hi,

My name is Wes Porter and I have been working for Neudesic approximately 2 years. My specialties include a fairly wide depth of technology from network infrastructure all the way to graphic design and a little bit of everything in between. Currently I have been focusing on Microsoft SharePoint implementations. SharePoint is one of Microsofts most intriguing software packages to date. The possibilities are absolutely endless. It has and will become the data repository for companies. When office 12 hits the product really takes off even though the existing product is already excellent. I will continue to post best practices, helpful hints and even fun stuff like how to tweak your XBOX and possibly some XBOX 360 game reviews. However, technology is only a part of my life. My life is really all about my children, wife and Jesus Christ. Enough about me! Here is my helpful hint for the day.

For those of you who already have a 2003 SharePoint installation you can enable HTTPS for your site with a few easy steps. The information is provided my Microsoft. Here is the link to it http://office.microsoft.com/en-us/assistance/CH011725171033.aspx

If you have any questions regarding this or any other SharePoint question please let me know.

Wes Porter

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!