SQL Server (MSSQLSERVER) Issue

[kgreer]

Let me try to explain my situation:
I have a Windows 2000 test server that we has SQL Server 2005 already installed on the machine. We have a software package in production that is using SQL 7.0. I am wanting to install the same Sofware Packaged on our Test server. So what I did was try to install SQL 7.0 on the test server that already has SQL 2005. The installation failed of course.

Here is my problem:
Now you can not connect to the SQL database because the SQL Server (MSSQLSERVER) service is not running. When you go to the properties and look at the path, it is pointint to the SQL 7.0 folder (C:\MSSQL7\binn\sqlservr.exe).

Here is my Question:
How do I change the path of a Service to point to the correct install?

I was able to get the service running by navigating to the folder and running the sqlservr.exe for 2005.

Thanks in advanced.

 

[hmckillop]

Simple Solution

Uninstall SQL 7
Reinstall SQL 2005


"I'm living so far beyond my income that we may almost be said to be living apart

 

[kgreer]

SQL 7 did not install correctly. So I cannot remove the app. So should I just try to re-install SQL 2005? It won't affect the current databases?