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?
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.
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.
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.