Right, this is a good one!
Had the LEA round installing Sims on our new 2003 server. This server has everything on it as the old Win2000 is being decommissioned. FMS installed fine but they had loads of problems with Sims so reinstalled SQL and Sims a number of times before it all worked ok. They configured the workstations but they were unable to test them because the ISA firewall was blocking connections. I wasn’t here yesterday so came in today and configured ISA so the workstation would work.
That was the good news…. When I opened services I started talking French because there are two of all the SQL services listed (see attachment). One set is running but the other set is disabled. The disabled services are referencing D:\Program Files\Microsoft SQL Server\MSSQL.1 and MSSQL.2 but these folders have been deleted. In Microsoft SQL Server folder there is MSSQL.3 and MSSQL.4. SQL Server (SIMS2005) and Server Agent (SIMS2005) are referencing MSSQL.3 and Analysis Services (SIMS2005) is referencing MSSQL.4.
How do I remove these disabled services? I don’t want to uninstall SQL as that will cause problem for Sims so I was hoping to edit the registry or something along those lines.
Mmm, another LEA botch job :rolleyes:
Disclaimer: I don't advise you actually do this, but if you want to remove the list entries they live in the registry:
There's a key for each service. IIRC you'll need to reboot before the change is reflected.
But I would just leave well alone, doing things like this can seriously damage your health.
I love the taste of SQL in the morning.
Thanks. I just found the same info here Delete a Service
Normally when I run the SQL uninstaller from the Add/Remove program wizard it asks me which instance I want to remove, instead of just removing everything. Is that not the case here?
you could also open command prompt.
sc delete < SERVICE name>
Thanks, that's probably the best way to do it.
Originally Posted by EduTech
Probably the Safest ;)
Originally Posted by Jobos