| Event Id | 19015 |
| Source | MSSQLServer |
| Description | Encryption requested but no valid certificate was found. SQL Server terminating. |
| Event Information | CAUSE: The Force protocol encryption option has been checked in the Server Network Utility for this SQL Server instance. This forces communication between all clients and this SQL Server instance to be encrypted through certificates. Therefore, if a certificate is not installed on the computer that is running SQL Server, or if SQL Server cannot validate that the certificate is appropriate for use with SSL-based encryption, SQL Server fails to start. RESOLUTION: For a nonclustered instance of SQL Server, you can choose to turn off the Force protocol encryption option. This option is available in the Server Network Utility as a check box. Turning this option off means that connections will no longer be encrypted. However, turning this option off is not possible for a clustered instance of SQL Server because once you have enabled server-side protocol encryption, you cannot turn it off. If you choose to use the Force protocol encryption option, you must ensure that the SQL Server instance has an available, properly configured certificate. 1. By default, SQL Server will look for a certificate issued to the fully qualified domain name of the server or virtual server on which the instance is installed. On a cluster, the certificate must exist on all nodes of the cluster. The registry key HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib (or the equivalent for a named instance) can be used to point to a certificate with a different name. The name of the key should be "Certificate" and it must be of type REG_BINARY. The setcert.exe utiltiy from the SQL Server 2000 Resource Kit can be used to set this value. 2. The certificate must exist in the Certificates\Current User Personal Certificates folder or the Certificates\Local Computer Personal Certificates folder. The SQL Server service account must have permission to access the certificate. 3. Verify that the certificate was originally issued for "server authenticat |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 19015 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.