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.
