Jobos Posted March 5, 2009 Posted March 5, 2009 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.
powdarrmonkey Posted March 5, 2009 Posted March 5, 2009 Mmm, another LEA botch job Disclaimer: I don't advise you actually do this, but if you want to remove the list entries they live in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services 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. 1
Jobos Posted March 5, 2009 Author Posted March 5, 2009 Thanks. I just found the same info here Delete a Service
AngryTechnician Posted March 5, 2009 Posted March 5, 2009 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?
EduTech Posted March 5, 2009 Posted March 5, 2009 you could also open command prompt. sc delete < SERVICE name> James. 2
Jobos Posted March 5, 2009 Author Posted March 5, 2009 you could also open command prompt. sc delete < SERVICE name> James. Thanks, that's probably the best way to do it.
EduTech Posted March 5, 2009 Posted March 5, 2009 Thanks, that's probably the best way to do it. Probably the Safest
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now