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

Fail to enumerate subscription properties

· 52CE 我爱测

This article provides a workaround for the error that occurs when you try to enumerate the properties of the subscription on a subscriber instance in SQL Server Management Studio.

This article helps you work around the problem that occurs when you try to enumerate the properties of the subscription on a subscriber instance in SQL Server Management Studio.

Original product version:   SQL Server 2017, SQL Server 2016
Original KB number:   4046801

Symptoms

Consider the following scenario:

  • You have configured an instance of Microsoft SQL Server 2016 or 2017 as a publisher and distributor.

  • You have configured either a push or pull subscription to a remote subscriber that's not configured as a publisher or distributor.

In this situation, if you try to enumerate the properties of the subscription on a subscriber instance in SQL Server Management Studio, you receive an error message that resembles the following:

Cannot apply value 'null' to property ServerInstance: Value cannot be null.

Workaround

To work around this issue, use replication monitor for the subscription status and progress.

Applies to

  • SQL Server 2017 on Linux (all editions)
  • SQL Server 2017 on Windows (all editions)
  • SQL Server 2016 Enterprise Core
  • SQL Server 2016 Standard
  • SQL Server 2016 Developer
  • SQL Server 2016 Enterprise
  • SQL Server 2016 Business Intelligence
  • SQL Server 2016 Web
  • SQL Server 2016 Express

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

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

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