How to remove a non-existing instance? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to remove a non-existing instance?

When a machine starts, it always get the message: The specified service does not exist as an installed service. The problem seems to be related to SQL Server Service Manager is pointing to a non-existing instance. How can I fix this? I believe this is something related to registry.
Check whether SCM utility exists on the server or not.
Check the registry key HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLSERVER/SQLSERVICEMANAGER and its values. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, When I type SCM in the Run, it will show the help on the arguments so I assume that it mean SCM is installed. I cannot find the registry key HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLSERVER/SQLSERVICEMANAGER in both Windows 2000 Server SP4 and Windows XP SP2 machines.
What is the error message in event viewer? Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I suspect the SCM utility is not properly set under registry and you might be getting the above error, do you have any other errors in the SQL server error logs & event viewer logs. Please post the exact Event viewer message with event ID etc. and when its occuring. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I will check the event log of that machine tomorrow. I find a registry key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server80ToolsService Manager and its subkeys: (Default)
Action Verify
Default
Remote
Services What is this key and its subkeys?
Thank you.
Subkeys are children of keys. All registry folder contained in keys are called subkeys.
Subkeys can contain entries and other subkeys.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, I guess I’m not too clear about my question. I actually interest to know what those keys are for.
As mentioned those are for Service Manager utility to function whenever system is rebooted. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>