Re: SQL Server 2005 SP2 fails in upgrading Database service

I discussed with folks on my team and it looks to be the problem described here: http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx

Thanks,
Peter Saddow - Microsoft

--
This posting is provided "AS IS" with no warranties, and confers no rights.



"Tjomme Vergauwen" <TjommeVergauwen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3FC0FC5B-4532-432A-9229-45D8B38FC966@xxxxxxxxxxxxxxxx
Hello,

Some extra remark: I installed the servicepacks when I was disconnected from
the network. Could this have something to do with it?

Tjomme

"Tjomme Vergauwen" wrote:

Hello,

When upgrading SQL Server 2005 with SP2 (KB921896), the Database service
upgrade failed.
Same problem when applying the fix (KB933508).
Now I'm unable to start the service all together... So I currently have no
database anymore.
Uninstall does only work for the fix, not for SP2...

I've included the summary dump and errorlog dump for analysis.
More logs available at request.

Thanks for the help!

Tjomme Vergauwen
Summary dump:
Command-line parameters specified:
Cluster Installation: No

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

**********************************************************************************
Products Detected Language Level Patch Level
Platform Edition
SQL Server Database Services 2005 (MSSQLSERVER) ENU SP2
2005.090.3042.00 x86 STANDARD
SQL Server Analysis Services 2005 (MSSQLSERVER) ENU SP2
2005.090.3042.00 x86 STANDARD
SQL Server Reporting Services 2005 (MSSQLSERVER) ENU SP2
9.00.3042.00 x86 STANDARD
SQL Server Notification Services 2005 ENU SP2 9.00.3042.00
x86 STANDARD
SQL Server Integration Services 2005 ENU SP2 9.00.3042.00
x86 STANDARD
SQL Server Tools and Workstation Components 2005 ENU SP2
9.2.3042 x86 STANDARD

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name
PID

**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933508_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (-2146885628) Cannot find object or property.

----------------------------------------------------------------------------------
Product : SQL Server Analysis Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) : 3050
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB933508_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Reporting Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) : 3050
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\RS9_Hotfix_KB933508_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Notification Services 2005
Product Version (Previous): 3042
Product Version (Final) : 3050
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\NS9_Hotfix_KB933508_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Integration Services 2005
Product Version (Previous): 3042
Product Version (Final) : 3050
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB933508_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 3042
Product Version (Final) : 3050
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB933508_sqlrun_tools.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

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


ERRORLOG dump:
2007-03-21 15:32:16.01 Server Microsoft SQL Server 2005 - 9.00.3050.00
(Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-03-21 15:32:16.01 Server Error: 17054, Severity: 16, State: 1.
2007-03-21 15:32:16.01 Server The current event was not reported to the
Windows Events log. Operating system error = 1502(The event log file is
full.). You may need to clear the Windows Events log if it is full.
2007-03-21 15:32:16.01 Server (c) 2005 Microsoft Corporation.
2007-03-21 15:32:16.01 Server All rights reserved.
2007-03-21 15:32:16.01 Server Server process ID is 3328.
2007-03-21 15:32:16.01 Server Authentication mode is MIXED.
2007-03-21 15:32:16.01 Server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-03-21 15:32:16.01 Server This instance of SQL Server last reported
using a process ID of 3488 at 3/21/2007 3:21:04 PM (local) 3/21/2007 2:21:04
PM (UTC). This is an informational message only; no user action is required.
2007-03-21 15:32:16.03 Server Registry startup parameters:
2007-03-21 15:32:16.03 Server -d C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-03-21 15:32:16.03 Server -e C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-03-21 15:32:16.03 Server -l C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-03-21 15:32:16.14 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2007-03-21 15:32:16.14 Server Detected 1 CPUs. This is an informational
message; no user action is required.
2007-03-21 15:32:16.46 Server Using dynamic lock allocation. Initial
allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is
an informational message only. No user action is required.
2007-03-21 15:32:16.56 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2007-03-21 15:32:18.64 Server Attempting to recover in-doubt
distributed transactions involving Microsoft Distributed Transaction
Coordinator (MS DTC). This is an informational message only. No user action
is required.
2007-03-21 15:32:18.65 Server Database mirroring has been enabled on
this instance of SQL Server.
2007-03-21 15:32:18.67 spid5s Starting up database 'master'.
2007-03-21 15:32:18.93 spid5s SQL Trace ID 1 was started by login "sa".
2007-03-21 15:32:18.95 spid5s Starting up database 'mssqlsystemresource'.
2007-03-21 15:32:18.99 spid5s The resource database build version is
9.00.3042. This is an informational message only. No user action is required.
2007-03-21 15:32:19.34 Server Error: 17182, Severity: 16, State: 1.
2007-03-21 15:32:19.34 Server TDSSNIClient initialization failed with
error 0xd, status code 0x38.
2007-03-21 15:32:19.34 Server Error: 17182, Severity: 16, State: 1.
2007-03-21 15:32:19.34 Server TDSSNIClient initialization failed with
error 0xd, status code 0x1.
2007-03-21 15:32:19.34 Server Error: 17826, Severity: 18, State: 3.
2007-03-21 15:32:19.34 Server Could not start the network library
because of an internal error in the network library. To determine the cause,
review the errors immediately preceding this one in the error log.
2007-03-21 15:32:19.34 Server Error: 17120, Severity: 16, State: 1.
2007-03-21 15:32:19.34 Server SQL Server could not spawn FRunCM thread.
Check the SQL Server error log and the Windows event logs for information
about possible related problems.



.

Relevant Pages

  • Re: Starting SQL Server Resource Group failed
    ... It looks like the Cluster Service cannot connect to the SQL Service to determine whether it is responsive or not. ... MS has not documented a process to fix this without uninstalling and reinstalling SQL Server. ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.clustering)
  • Re: New install, Small Business Server 2003
    ... I am attempting to get SQL Server 2005 Express running on a freshly ... "Configuring Database Services" stage of the install I get an error ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • Re: New install, Small Business Server 2003
    ... I am attempting to get SQL Server 2005 Express running on a freshly ... "Configuring Database Services" stage of the install I get an error ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... Now I removed the account from local Administrators group. ... The SQL Server Log File reports an error 15209, ... Note that I use a specific account named SQLServerServices to install ... This is an informational message only. ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005 Logon Issues
    ... an ASP.NET 2.0 application to connect to a SQL Server 2005 database... ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ... This is an informational message only; no user action is required. ...
    (microsoft.public.dotnet.framework.aspnet)