大网数据广告活动
数据库与应用安全

Can't install SQL Server when only an RODC is reachable

· 52CE 我爱测

This article discusses an issue in which you can't install SQL Server when only a read-only domain controller (RODC) is available.

This article discusses an issue in which you can't install SQL Server when only a read-only domain controller (RODC) is available.

Original product version:   SQL Server
Original KB number:   2962968

Symptoms

Consider the following scenario:

  • You have a perimeter network (also known as a demilitarized zone (DMZ), and a screened subnet) that only has an RODC available.
  • You have a member server in the perimeter network. You try to install SQL Server on the member server and use an Active Directory service account for the SQL Server service.

In this scenario, the installation wizard fails when the installation program validates your account.

Cause

When you log on to a computer for the first time and try to encrypt data, the operating system creates a preferred Data Protection Application Programming Interface (DPAPI) MasterKey, which is based on your current password. During the creation of the DPAPI MasterKey, an attempt is made to back up this master key by contacting a Read Write Domain Controller (RWDC). If the backup fails, the MasterKey can't be created, and this results in failure.

Workaround

To work around this issue, perform the following:

  1. Use the built-in account to install SQL Server.
  2. Change the account that is used for the services to an Active Directory service account.

For other resolutions and additional information, see DPAPI MasterKey backup failures.

References

Installing SQL Server on a domain controller

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 11/08/2022
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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