Category Archives: SQL 2008

Microsoft SQL Servername does not match computer name

Anyone who has downloaded any of the Microsoft Hydration kits of late looking to import them into their own lab especially in my case as SQL 2008 is becoming harder and harder to get hold of nowadays may of stumbled over just what I did today.

By renaming the machine and joining to my lab domain generated a warning in OpsMgr pre-req as machine name was different to when SQL was installed.

Quickly resolved in management studio by the following:

 

Confirm current name – select @@ServerName

 

Then execute the following statements.

Run Query from the SQL query window one statement at a time

sp_dropserver ‘old_server_name’
sp_addserver ‘new_server_name’, ‘local’

My Server required a reboot to pick up the changes!