SQL Service Pack doesn't upgrade SQL Server

From: Gregory D. Hess (gdh@fsproduce.com)
Date: 03/12/03

  • Next message: Chip Andrews: "Re: SQL Service Pack doesn't upgrade SQL Server" 
    Date: Wed, 12 Mar 2003 16:20:15 -0500
From: "Gregory D. Hess" <gdh@fsproduce.com>
To: "Focus-Ms (E-mail)" <focus-ms@securityfocus.com>

    I am trying to upgrade an SQL Server 2000 Standard Edition from RTM to service pack 3. I downloaded and extracted the files, backed up the databases and shutdown SQL Server. Then I ran x86\setup\setupsql.exe as directed in the SP3 Readme file. After setup was complete I was asked to reboot the server. When it came back up I checked the version, and it is still at RTM (8.00.194). I received no errors during the install that would suggest that the upgrade was not successful, yet for some reason it was. I also tried upgrading to SP1, and got the same results.

    For the Authentication mode I used SQL authentication and gave the sa password. The server is a W2k Domain Controller on Windows service pack 3. There is only one SQL Server instance on this computer.

    What would cause the SQL service pack not to install?

    -Greg Hess

  • Next message: Chip Andrews: "Re: SQL Service Pack doesn't upgrade SQL Server"

    Relevant Pages