Re: SQL Server 2005 SP2 fails in upgrading Database service

Hi Tjomme,

The status code 0x38 in the error:

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.

indicates a problem with the "Certificate" entry in the SQL Server's
registry. 0xd is equivalent to ERROR_INVALID_DATA.
What you need to do to allow SQL Server to start successfully is to check
and correct the "Certificate" registry entry, usually under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.#\MSSQLServer\SuperSocketNetLib. You need to make sure that the
Certificate entry is present, of type REG_SZ and either containing a valid
certificate name or is cleared out.

The problem is also described in the following KB article:
http://support.microsoft.com/?id=900497

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


"Tjomme Vergauwen" wrote:

Hello Peter,

This is the complete log.
I have another more detailed log in the file C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933508_sqlrun_sql.msp.log

This one is too big to post here.
If it can help, I gradly send it to you via e-mail.

Regards,
Tjomme

"PeterSadd" wrote:

Tjomme is the errorlog below, the complete log?

Thanks,
Peter Saddow

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



"PeterSadd" <petersad@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23u0q2FLbHHA.2552@xxxxxxxxxxxxxxxxxxxxxxx
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: SQL Sever 2008 RC0 fail to install almost all services
    ... > SQL server services. ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • Cannot move msdb/model even with -T3608
    ... Our SQL instance is a named one and has the following ... This is an informational message only. ... no user action is required. ... System databases master, model, msdb, and tempdb cannot be detached. ...
    (comp.databases.ms-sqlserver)
  • 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: SQL Server Express 2005 setup crash!!
    ... Mike Epprecht, Microsoft SQL Server MVP ... > Mike Epprecht, Microsoft SQL Server MVP ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • SQL Issues with winserver 2003 small business standard
    ... I have a 2003 small business server, a few days ago it was working perfect ... sql, i noticed that the sql service has stopped i tried to start but i ... This is an informational message only; no user action is required. ...
    (microsoft.public.windows.server.sbs)