cant update to sql service pack 2?

[miscluce]

I am trying to update to sQL SP2 but I keep getting an error during the authentication. It says user could not be verified, for setup to verify credentails services must be started and connectable. It says Success in the status column for SQL database services so I dont understand why I am getting this. I am logged into teh domain and using vista business SP1. So far I dont see a problem with running SQL managment studio. I just cant update SQL.

 

[JohnBates]

I have the same problem on a Windows 2003 server. SP2 simply will not install, no matter how/who I'm logged in as.
Weird. If you find a fix, please post back.

John

 

[mrdenny]

Try starting the SQL Server from a command prompt using the -c switch and then run the service pack installer. This used to work in SQL 2000 SP3.

Are you running a named instance or the default instance?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JohnBates]

mrdenny,

I'm not trying to jump in on miscluce' post... but, no I'm using the default instance.

Thanks, John

 

[miscluce]

I am using a named Intsance.

how do I do this?

Try starting the SQL Server from a command prompt using the -c switch and then run the service pack installer.

 

[mrdenny]

John,
No problem. The same technique should work for you as well.

Miscluce,
For a named instance you need to add the -s switch along with the name of the instance.

sqlservr.exe -c -s InstanceName

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[miscluce]

Thanks but I am still getting an error during the authentication.

 

[JayKusch]

Can you post the error message?

Is it the same error you have been getting in the past?

What account is being used for the SQL Server services?

Are you set as a SysAdmin in the SQL instance?

Thanks

J. Kusch

 

[mrdenny]

Can you post the ERRORLOG from when the upgrade is running?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[miscluce]

Can you post the error message?
"Your account information could not be verified. Press OK to return to authentication mode screen to determine reason for failure.

For setup to verify your credentials the services must be startble, connectable. and you must be SQL server admin."

Is it the same error you have been getting in the past?
"YEs"

What account is being used for the SQL Server services?
not sure but I think this is a seperate account set up for this which is a domain admin

Are you set as a SysAdmin in the SQL instance?
yes

 

[miscluce]

Can you post the ERRORLOG from when the upgrade is running?

where do I find this?

 

[mrdenny]

By default it'll be in c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[SQLWilts]

Hi, sorry to but in,
Does the account that you are logging onto the SQL server as have sa access? In other words, if you are logging in under windows authentication, is that windows user a member of a group that is a member of, or is that login a member of the sysadmin server role?
Also, is the SQLAgent started?

 

[mrdenny]

Wilts,
An excellent point.

miscluce,
Can you log into the SQL Server while it's running normally and run the following and let us know the result.

select IS_SRVROLEMEMBER('sysadmin')

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[miscluce]

I ran this "select IS_SRVROLEMEMBER('sysadmin')"

result looks like this:

(no column name)
1 | 1

 

[SQLWilts]

miscluce,
OK, I'm going to be the one to ask the stupid question here - you wouldn't be trying to upgrade analysis services as well as the DB services are you? If so, do you have the correct login for that? Also, are you selecting the correct instance to upgrade?

Could you give this simple man a blow-by-blow account of what buttons you are clicking and what options you are taking from the double-click of the SP2 file please?

thanks

 

[SQLWilts]

Are these clustered installations?

 

[SQLWilts]

Found this om MS knowledgebase

http://support.microsoft.com/?kbid=932870

It says to use the netbios name of the domain profile when signing on rather than the FQDN (fully qualified domain name)

 

[miscluce]

OK now it gets passed the authentication but fails to update the databse:

update summary

Time: 08/18/2008 16:19:24.257
KB Number: KB921896
Machine: OSIT5
OS Version: Professional Service Pack 1 (Build 6001)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 DEVELOPER
Analysis Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER
Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 DEVELOPER
Notification Services ENU SP2 9.00.3054.00 x86 STANDARD
Integration Services ENU SP2 9.00.3054.00 x86 DEVELOPER
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU SP2 9.2.3054 x86 DEVELOPER
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason
Analysis Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Notification Services The product instance NS been patched with more recent updates.
Integration Services The product instance Integration Services been patched with more recent updates.
Client Components The product instance SQL Tools been patched with more recent updates.

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQLSERVER Database Services Service 1872
SQLSERVERAGENT Database Services Service 2756

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29565
Error Description : MSP Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance MSSQLSERVER and complete the setup.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance NS been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance Integration Services been patched with more recent updates.
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance SQL Tools been patched with more recent updates.
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29565

 

[SQLWilts]

Hiya,
the answers in the log

MSP Error: 29565  SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance MSSQLSERVER and complete the setup.

This was probably caused by the authentication error failure earlier.
Are you logged on the the server where this SQL 2005 Developer instance is installed? If you can (RDP would do it...) then that would be best to go to control panel/add remove programs and complete the SQL install