I needed to remove an MSDE instance from the SQL Server Service Manager because it no longer existed and I was annoyed by the error message I was receiving each time I logged onto the server. After to many unsuccessful Google searches, I just decided to open the registry and fire up the good old "F3" ("Find Next" function -- also found via the Edit menu) to look for the name of the instance I was trying to get rid of to see if I could edit it manually.
THANK GOD! It was actually extremely simple and successful.
If ever you run into the same situation as me, here is the registry key and the value you are looking for:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances
It is a Multi-String Value (REG_MULTI_SZ) and it's as easy as removing the instance in question from the list.
Wish I would have felt like spending a few minutes doing this months ago.
Tuesday, October 21, 2008
Subscribe to:
Posts (Atom)