“Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 StandardSQL Server 2016 Developer


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:



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.