July 1, 2004 at 11:14 am
I hope this will make sense..
I got a request to install SQL Server 2000 Client Tools on a Windows 2000 users machine. I did notice that SQL Server 7.0 was installed, and i assumed that the SQL Server 2000 install would upgrade the existing tools.
What has happened is that it installed the 2000 client tools - and apparently upgraded the 7.0 tools but the user neglected to tell me that they also had a Local SQL Server 7.0 instance on his machine that he needed upgrading as well.
Now that I have run the SQL Server 200 install, I cannot start the old 7.0 instance. From the Start menu, it finds the Service Manager ICON for the ond 7.0 instance, but when I try and run the Service Manager to start the instance, it cannot find the .exe file - I get an error that says "redirection EXE error" Can anyone help me figure out how to back out of this or rectify it??
July 1, 2004 at 11:20 am
Have you tried just starting the services directly (Right click on My Computer, select Manage, find Services and then start the appropriate services)?
Did the SQL Server 2000 install load a new Service Manager? Have you tried to see if you can start the 7.0 services from there?
-SQLBill
July 1, 2004 at 11:21 am
Last possibility that I can think of:
Have you tried reinstalling the 7.0 Client Tools? Maybe in a different location?
-SQLBill
July 1, 2004 at 11:32 am
When I go into Services, the mssqlserver service IS Started. and when I look at the properties for the service, it is running from the old 'mssql7' directory.
All of the original files still exist for the 7.o instance. there are .mdf and .ldf files for master, model, tempdb and msdbdata and user databases - I just can't get the instance started.
Maybe I installed the wrong SQL Server 2000 Version? I ran the full-blown SQL Server 2000 install which only installs Client tools on this kind of machine.
The SQL Server 2000 install DID NOT install it's own Service Manager - only the Client tools (which work).
I guess what I WANTED to do was install a version of SQL Server 2000 which would upgrade the local 7.0 Instance. I'm not sure what verision I SHOULD have installed!!??!!
July 2, 2004 at 8:29 am
You say that the mssqlserver service IS started, but you can't start the "instance". The mssqlserver service IS the "instance". If the service is running, SQL 7.0 is running. You said also that the 2000 client tools work. You can verify that 7.0 is running by using the 2000 tools and registering the local instance. You can administer 7.0 from 2000 enterprise manager.
Finally, if you are wanting to upgrade the 7.0 instance, you can do that with the SQL Server 2000 Enterprise Edition/Personal Edition software.
Steve
July 2, 2004 at 8:37 am
Yes, the mssqlserver service IS started when I check services on the machine, and I can register and manage the old 7.0 instance using my 'new' 2000 Tools. I guess my concern is before I ran the 2000 install - I had a 7.0 Service Manager to start and stop the instance, it is still there in my start menu, I just that error when I try and run it.
I originally ran the SQL Server 2000 Enterprise Edition install which only installs client tools on a windows 2000 workstation. I did not realize that there is a SQL Server 2000 Personal Edition software. I will try running that to see if it upgrades the 7.0 instance on the machine.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply