Problems installing SP3

• sokeeffe

  SSC Journeyman

  Points: 76

  More actions

  February 11, 2003 at 5:55 am

  #64292

  I keep getting a message during installation that says: 'setup was unable to verify state of the server for an upgrade. verfiy the server is able to start and that you provided a valid sa password and restart setup'

  All the NT services packs had been installed before I downloaded the patch. I checked the sa password and it is correct. I could restart the server and restart SQL Server. I read through some of the previous posting and upgraded from MDAC 2.6 to 2.7 Refresh. Alas, the same message is still appears and it is driving me nuts!

  Can anyone help?

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  February 11, 2003 at 6:25 am

  #448614

  Can you post the last ten 10 lines or so from your sqlsp.log? Typically it's in C:\WINNT\ or C:\WINDOWS\ or wherever your system root is.

  There was a problem in SP2 with spaces in the path for the TEMP variable path and I am wondering if it is related:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;328290

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley

• sokeeffe

  SSC Journeyman

  Points: 76

  More actions

  February 11, 2003 at 7:07 am

  #448617

  So far so good. Removing the space from the directory name has not brought up the error and appears to be installing the SP. Hooray!

  Thanks so much.

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  February 11, 2003 at 7:53 am

  #448625

  Excellent!

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley