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.