大网数据广告活动
启动与系统组件

SQL Server Always On protection fails with error 0x80990F75

· 52CE 我爱测

Fixes an issue where you receive error 0x80990F75 when attempting to protect a SQL Server Always On Availability Group in Data Protection Manager.

This article helps you fix an issue where you receive error 0x80990F75 when attempting to protect a SQL Server Always On Availability Group in Data Protection Manager (DPM).

Original product version:   System Center 2012 Data Protection Manager
Original KB number:   2769094

Symptoms

When attempting to protect a SQL Server Always On Availability Group using System Center 2012 Data Protection Manager, the job fails with the following error:

The DPM job failed for SQL Server 2012 database <DBname> on <serverName> because the SQL Server instance refused a connection to the protection agent. (ID 30172 Details: Internal error code: 0x80990F75)

In SQL Server, Always On is configured as follows:

  • Availability Mode: Synchronous Commit
  • Failover Mode: Automatic
  • Connections in Primary Role: Allow all connections
  • Readable Secondary: No
  • Backup Preferences:
    • Prefer Secondary
    • Priority: 50 (for each node)
    • Exclude Replica: False (for each node)

In general, Prefer Secondary backups should occur on a secondary replica except when the primary replica is the only replica online. If there are multiple secondary replicas available, the node with the highest backup priority will be selected for backup. In the case that only primary replica is available then backup should occur on the primary replica.

Cause

This occurs due to incorrect SQL Server Always On settings for DPM backups where Make Readable Secondary is set to No.

Resolution

Set Make Readable Secondary to Yes on all the nodes.

More information

If setting Make Readable Secondary to Yes on all the nodes doesn't resolve the issue, verify on the SQL Server that the DPMRA service is running under the Local System account and that the NT Authority\System has the sysadmin selected for the server role in SQL Server Management Studio.

  1. On the SQL Server side, the DPMRA service should run under the Local System account. You can verify this via services in computer management.
  2. In SQL Server 2012 Management Studio, connect to the SQL Server 2012 instance. Then select and expand Security > Logins, right-click NT AUTHORITY\SYSTEM, select Properties > Server roles, check the sysadmin checkbox, and then click OK.

After this, in certain cases it may also be necessary to reinstall the DPM agent on the SQL Server or manually run the SetDPMServer command on the SQL Server specifying the DPM server.

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 04/08/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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