SQL 2000 installation on WinXP Pro problems

[David]

I'm trying to install SQL 2000 Standard on WinXP Pro; I only need to
install the Enterprise Manager and the Query Analyser. Early in the
installation I get the message

A previous program installation created pending file
operations on the installation machine.
You must restart the computer before running setup.

I've restarted the machine a few times and have even uninstalled
software that I thought suspicious. I know what the error message
means but I have no idea how to solve this problem. Any help would be
greatly appreciated.

Thanks,

David

P.S.: Could Spybot be the culprit?

[Simon Hayes]

"David" <dj******@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I'm trying to install SQL 2000 Standard on WinXP Pro; I only need to
install the Enterprise Manager and the Query Analyser. Early in the
installation I get the message

A previous program installation created pending file
operations on the installation machine.
You must restart the computer before running setup.

I've restarted the machine a few times and have even uninstalled
software that I thought suspicious. I know what the error message
means but I have no idea how to solve this problem. Any help would be
greatly appreciated.

Thanks,

David

P.S.: Could Spybot be the culprit?

http://support.microsoft.com/default...b;en-us;312995

Simon

[dbahooker]

you need to make sure that you have SP4 installed on the client right?

that's why i like having a local copy of sql server-- use the
developers edition on the desktop and do a full install.. and appy SP4
on your desktop and on the server

that's the best route in my book.. as it is.. you probably dont have
the latest version of EM and QA.. might not even let you connect in
some situations

[ibrahimhassan]

hi David, try this and I'm sure it'll Solve it...


1. Restart the computer and see if you are able to run the setup. If the restart does not help, use the steps that follow:
2. Perform these steps and then run the SQL Server 2000 setup again: a. Click Start, and then click Run.
b. In the Open dialog box, type: "Regedit" (without the quotation marks) or "Regedt32" (without the quotation marks)


c. Click OK.

NOTE: Please make sure that you only delete the value mentioned, not the whole session manager key.


d. In Registry Editor, expand the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet \Control\Session Manager


e. On the File menu, click Export.

NOTE: In Microsoft Windows 2000, click Export Registry File from the Registry menu.


f. In the File name text box, type: "Session Manager Key" (without the quotation marks)


g. Click Save.
h. In the right-pane of the Registry Editor window, right-click PendingFileRenameOperations. On the shortcut menu that appears, click Delete.
i. In the Confirm Value Delete message dialog box that appears, click Yes.
j. On the File menu, click Exit.

NOTE: In Windows 2000, click Exit on the Registry menu.


k. Restart the computer.
l. Using the Registry Editor, verify that the PendingFileRenameOperations registry value is not available.