Consider the following scenario:
- You have configured an instance of Microsoft SQL Server 2017 or Microsoft SQL Server 2016 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."
To work around this issue, use replication monitor for the subscription status and progress.
Microsoft has confirmed that this is a problem in SQL Server, and is currently researching a fix. This article will be updated with additional information as it becomes available.