Details | |
Product: | SQL Server |
Event ID: | 19015 |
Source: | MSSQLServer |
Version: | 8.0 |
Component: | SQL Engine |
Message: | Encryption requested but no valid certificate was found. SQL Server terminating. |
Explanation | |
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. | |
User Action | |
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. For more information about the Force protocol encryption option on a clustered instance, see Microsoft Knowledge Base article 319349.
If you choose to use the Force protocol encryption option, you must ensure that the SQL Server instance has an available, properly configured certificate. For more information about how SQL Server uses a certificate when the Force protocol encryption option is on, see Microsoft Knowledge Base article 318605.
|