Lesson Learned #116: Replication Monitor and Azure Manage Instance public endpoint

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

I've found that launching replication monitor feature from SQL Server Management Studio connected to Azure Manage Instance public endpoint doesn't show data.

 

I worked on a service request that we found that using SQL Server Management Studio connected to the Azure Managed Instance Public Endpoint doesn't show data, however, using the private endpoint we have all the details. 

 

Why?. Running SQL Server Profiler Trace I've found that Replication Monitor executes the following TSQL: exec sp_helpdistpublisher N'servername.PUBLIC.clustername.database.windows.net,3342' that tries to retrieve information about the replication definition details, but, the information is saved using the private name. So, using the Azure Managed Instance Private endpoint like this one: exec sp_helpdistpublisher N'servername.clustername.database.windows.net' all information is obtained. 

 

Enjoy!

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.