大网数据广告活动
服务器运维问答

What is the location of the SQL Server Fallback Certificate?

· 52CE 我爱测

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal certificate to do the encrypting. …

问题原文

原帖链接 · tresstylez · CC BY-SA 3.0

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal certificate to do the encrypting.

We need to understand what level of encryption this is providing. I think we generally use 2048bit certs.

Which certificate store is the internal/fallback certificate located? And how can we get the encryption level?

已采纳解答

原帖链接 · HopelessN00b · CC BY-SA 4.0

By default, the certificate is located in the registry, at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib

(Where the MSSQL.x is MSSQL.x is a placeholder for the corresponding value of the instance of SQL Server.)

If SQL server cannot find a certificate at that location, it will fall back to searching the certificate store for a certificate with the FQDN of the computer it is installed on. By default, that certificate would be the machine certificate, found in Local Computer -> Personal -> Certificates through the MMC Certificates snap-in.

You would check the key length (and other properties) of this (or any) certificate through the MMC Certificates snap-in, by browsing to it, double clicking on it, and then hitting the Details tab in the ensuing dialogue box that comes up for the certificate.

If this cert is also unavailable, then SQL Server will generate a self-signed fallback certificate and use this for encryption. You can view the thumbprint or certificate being used when viewing the error logs around when SQL service restarts. The location of this fallback certificate is not officially known and other forums have suggested that this likely resides in memory. Please refer here for more info

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2013-12-18)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0 / CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。