Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1077223%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23116%3A%20Replication%20Monitor%20and%20Azure%20Manage%20Instance%20public%20endpoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1077223%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20found%20that%20launching%20replication%20monitor%20feature%20from%20SQL%20Server%20Management%20Studio%20connected%20to%20Azure%20Manage%20Instance%20public%20endpoint%20doesn't%20show%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20worked%20on%20a%20service%20request%20that%20we%20found%20that%20using%20SQL%20Server%20Management%20Studio%20connected%20to%20the%20Azure%20Managed%20Instance%20Public%20Endpoint%20doesn't%20show%20data%2C%20however%2C%20using%20the%20private%20endpoint%20we%20have%20all%20the%20details.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EWhy%3F%3C%2FSTRONG%3E.%20Running%20SQL%20Server%20Profiler%20Trace%20I've%20found%20that%20Replication%20Monitor%20executes%20the%20following%20TSQL%3A%26nbsp%3B%3CSTRONG%3Eexec%20sp_helpdistpublisher%20N'servername.PUBLIC.clustername.database.windows.net%2C3342'%3C%2FSTRONG%3E%20that%20tries%20to%20retrieve%20information%20about%20the%20replication%20definition%20details%2C%20but%2C%20the%20information%20is%20saved%20using%20the%20private%20name.%20So%2C%20using%20the%20Azure%20Managed%20Instance%20Private%20endpoint%20like%20this%20one%3A%20exec%20%3CSTRONG%3Esp_helpdistpublisher%20N'servername.clustername.database.windows.net'%3C%2FSTRONG%3E%20all%20information%20is%20obtained.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnjoy!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1077223%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20found%20that%20launching%20replication%20monitor%20feature%20from%20SQL%20Server%20Management%20Studio%20connected%20to%20Azure%20Manage%20Instance%20public%20endpoint%20doesn't%20show%20data.%3C%2FP%3E%3C%2FLINGO-TEASER%3E

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!