Re: SQL-Server startet nicht ...

Hallo Lutz,

Lutz Uhlmann schrieb:
Ich glaube das Problem liegt irgendwo bei dem selbgenerierten Zertifikat des Servers ...

* Defekter SQL-Server 2005 (ohne Force Encryption) (Dienst startet)
2008-09-16 12:26:46.10 Server Fehler: 26015, Schweregrad: 16, Status: 1.
2008-09-16 12:26:46.10 Server Unable to load user-specified certificate. Because connection encryption is required, the server will not be able to accept any connections. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.
2008-09-16 12:26:46.10 Server Fehler: 17182, Schweregrad: 16, Status: 1.
2008-09-16 12:26:46.10 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2008-09-16 12:26:46.10 Server Fehler: 17182, Schweregrad: 16, Status: 1.
2008-09-16 12:26:46.10 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2008-09-16 12:26:46.12 Server Fehler: 17826, Schweregrad: 18, Status: 3.

Für die obige Kombination gibt es einen ARtikel
<URL:http://support.microsoft.com/kb/928779>
"The SQL Server service cannot start after you configure an instance
of SQL Server 2005 to use a Secure Sockets Layer (SSL) certificate using
the Microsoft Enhanced Cryptographic Provider 1.0"

wobei mir allerdings schleierhaft ist, wieso es erst nach dem Absturz
auftreten sollte.

Prüfe das Zertifikat auf Gültigkeit. Und wenn Du eine Sicherung hast,
spiele sie ein. Ansonsten bleibt wohl nur ein neues Zertifikat zu
generieren: <URL:http://msdn.microsoft.com/en-us/library/ms186362(SQL.90).aspx>

Gruß Elmar






2008-09-16 12:26:46.12 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.
2008-09-16 12:26:46.12 Server Fehler: 17120, Schweregrad: 16, Status: 1.
2008-09-16 12:26:46.12 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.

* Anderer laufender SQL-Server-Express (mit Force Encryption) (Dienst startet)
2008-09-16 12:47:24.73 spid8s Clearing tempdb database.
2008-09-16 12:47:25.29 Server A self-generated certificate was successfully loaded for encryption.
2008-09-16 12:47:25.32 Server Server is listening on [ 'any' <ipv4> 1433].


.

Relevant Pages

  • RE: Help Newbie..Upload file from SQL Server
    ... Enable SSL Encryption for SQL Server 2000 with Microsoft Management ... Steps to Use to Install a Certificate on a Server with Microsoft Management ... Steps to Enable Encryption for a Specific Client ...
    (microsoft.public.sqlserver.programming)
  • Encrypting off-site with certificates public key
    ... I thought it would be wise to use a certificate encryption scheme to allow ... Then the data is written into a varbinarycolumn on the central server ... For some reason the public key is generating a different algorithm on .NET ...
    (microsoft.public.sqlserver.security)
  • Re: Policy settings tool and username tokens (not x509)
    ... the wse setup tool is telling me "I'm making you give me an x509 server cert ... to do any encryption, something isn't right. ... > Having both client and server tokens allows the default WSE client to ... > require that the CN name in the certificate match the name of the ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • RPC over HTTP, Microsoft solution
    ... Exchange Server 2003 RPC over HTTP Deployment Scenarios ... Place a check in the box next to 'Certificate Services' and click 'Yes' ...
    (microsoft.public.exchange.setup)
  • Re: OWA 2003 w/ Smart Card Authentication.
    ... Exchange 2003 server via ActivSync. ... the IIS certificate. ... Whether or not authentication will succeed is completely dictated by ... Server's SSL certificate must be configured on root of v-server via ...
    (microsoft.public.exchange.connectivity)