Friday 11 July 2014

SQL INF SQL-DMO Error 1722: Service Control Error

Root Cause: SQL Server name does not match the Windows NT machine name
Solution:
Go to SQL Management studio
Run this: SELECT @@servername
You will get : SQL Server name
Now...
Use "sp_dropserver <SQL Server name>" to drop the wrong name.
Use "sp_addserver <machine name>, LOCAL" to set the SQL Server name to the machine name.
Stop and restart the MSSQLServer service for the change to take affect.