Sql 7 SP4 Not working

[rozesket]

I am trying to upgrade my Sql Server to Sp4,

The problem that I get is that when I click on the setup.bat file to begin the install of Sp4, I get a message that says this install has bee tried on this computer before do you want to Retry of Cancel (even though this is the first time for Sp4)? I click on retry, and it goes a bit, and then gives me another error, that says It can't run one of the Scripts and asks again if I want to retry, so I do, and it fails again. It did not upgrade to SP4. I had this same problem with SP3, yet it did upgrade it to Sp3.

First, How do I get the message that say this has been tried before to go away? Am I doing something wrong?

Please Help.

[rmiao]

Any message in setup log file?

[rozesket]

Attached is what I could find.

[rmiao]

Do you have b: and l: drive on your server?

[rozesket]

No, I am not sure why it did that. It is C: and F:

[rmiao]

Try copy sp4 to local drive and run setup locally.

[rozesket]

That is how I am currently running the setup.

[rmiao]

Where did you get sp4 files? Download from Microsoft again, reboot server before running setup.

[rozesket]

I downloaded the file from Microsoft. I have tried it 3 times.

[rmiao]

Try contact Microsoft for the issue then.

[jas81864]

Something (or someone) is attempting to attach to SQL while you are doing the upgrade. SQL must lock most of the databases in single user mode to do the update. Someone is getting that single connection, so then when the upgrade attempts to connect it cannot. I have had to go as far as disconnect the network cable before to keep connections out while I was doing the upgrade.

[rozesket]

Thanks, I kind of assumed something like that. We have SMS on this SQL Server, so How can I stop it? Maybe Pulling the network cable out is what I will need to do also. Thanks again.

[rmiao]

Or stop sms service for a while.

[jannat]

You just have to stop SQL server services before you attempt to do the upgrade, don't need to take out the network connections or anything like that.

[jas81864]

SQL brings the services up and down a few times during the upgrade process in single user mode. If a users attempts a connection during this time it can still cause upgrade failures.