Re: SQL Server 2005 SP2 fails in upgrading Database service

Hello Jivko,

Clearing the certificate had no success.
The service logged on with the Local service built-in account.
When I changed this to Local System, it works !

Thanks for the suggestion!

Regards,
Tjomme

"Jivko Dobrev - MSFT" wrote:

Hi Tjomme,

The error is described as SEC_E_UNKNOWN_CREDENTIALS, i.e. the credentials
provided to SSPI were not recognized. Would you be able to provide the exact
error from the errorlog?
I suspect there's a problem with the permissions of the SQL Server service
account. Is it LocalSystem, Network Service or a domain account? Could you
try to change it? Also - could you go to the Configuration Manager, open
properties of the "Protocols for ...<your instance>" then go to the
Certificate tab and click "Clear".

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

"Tjomme Vergauwen" wrote:

Hello Jim,

When I clear the Certificate in the registry, I get the error that he is
unable to create a self-signed certificate.
returned erro code: 0x8009030d

Any ideas?

Tjomme

"Jivko Dobrev - MSFT" wrote:

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.
.

Relevant Pages

  • 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)
  • Re: SQL2005: Running TSQL commands in single-user mode
    ... This is an informational message only. ... no user action is required. ... on this instance of SQL Server. ... Database may not be activated yet or may be in transition. ...
    (comp.databases.ms-sqlserver)
  • 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: 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)