Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error with SQL SP3 install

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-19 : 08:24:34
Dragan writes "Upon trying to install SP3 I get the following error:

"Setup was unable to verify the state of the server for an upgrade. Verify the server is able to start and that you provided a valid sa password and restart setup"

Can anybody shed some light, please?
I installed SQL 2000 Std.
The OS is Win2003.

This was the only solution Microsoft had so far, http://support.microsoft.com/kb/328290, but it doesn't work."

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-04-19 : 12:02:45
Did you reboot the server after the install of SQL server???



Andy

Beauty is in the eyes of the beerholder
Go to Top of Page

Amanda D
Starting Member

4 Posts

Posted - 2005-04-22 : 17:24:49
Can you tell me what you did to resolve your issue? i am having the same issue/message and have rebooted more times than I care to mention...
Go to Top of Page

pentiumsingh
Starting Member

9 Posts

Posted - 2005-04-25 : 00:55:52
Hi
after restarting and installing sp3 ,
your sql server service and all the related services like agent and others are started

And if you have kept the 'sa' password as blank password then please insert some password into it ,
and keep the authentication mode to mixed mode
that is your windows authentication and sql autentication both

Pentiumsingh
Go to Top of Page

Amanda D
Starting Member

4 Posts

Posted - 2005-04-25 : 09:24:26
quote:
Originally posted by pentiumsingh

Hi
after restarting and installing sp3 ,
your sql server service and all the related services like agent and others are started

And if you have kept the 'sa' password as blank password then please insert some password into it ,
and keep the authentication mode to mixed mode
that is your windows authentication and sql autentication both

Pentiumsingh

Go to Top of Page

Amanda D
Starting Member

4 Posts

Posted - 2005-04-25 : 09:25:10
Hi - thanks for responding. My sa password is sa and does work when I test it to create a odbc source....Any other thoughts?
Go to Top of Page
   

- Advertisement -