sp_adddistpublisher on Azure SQL Managed Instance
In Azure SQL Managed Instance environment,
We tried to configure publisher on managed instance via execute following command. After that, we ran exec sp_helpdistpublisher 'azure sql managed instance name' to check and got the empty result.
EXEC spadddistpublisher @publisher = @@ServerName,
@distributiondb = N'distribution',
@securitymode = 0,
@login = N'<SQLUSER>',
@password = N'<PASSWORD>',
@workingdirectory = N'\<STORAGEACCOUNT>.file.core.windows.net<SHARE>',
@storageconnectionstring = N'<STORAGECONNECTIONSTRING>';
In contrary, we are able to use SSMS manually configure publisher.
But we could not input @storageconnectionstring parameter in the properties of publisher.
Could you please check if the sp_adddistpublisher running on azure sql managed instance has problem on replication part?