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_addserver ‘new_server_name’, ‘local’
My Server required a reboot to pick up the changes!