Windows Forum

Ask something
Discussion Locked

SQL Error

0 helpful
1 reply

by dkent

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are seeing an unusual error occur. We have SQL server 2000 but whoever installed it (before my time here) seems to have installed in multiple locations, reinstalling it and not removing all the files. My problem is that while trying to update SQL to the newest version it will not take the Service Pack. anyone have any sugestions on what I can do to get this SP to install properly.
Thanks for any help you can give me.

1 reply

by rawright

I ran into that trying to install service packs on SQL Server 7. I finally resorted to shutting down SQLS7 and all its services manually, then installed the SPs without difficulty. The part I couldn't figure was that, although nothing I know of on my machine is using SQL Server, I couldn't make this process work without rebooting the machine, then shutting down all the SQL stuff before doing anything else. The process I followed was: shut down; restart; kill SQL Server; open Services and shut down anything related to SQL Server; install the service pack; restart the machine.

This discussion is closed to new replies.