I am trying to set up a Snapshot replication using an Azure SQL Managed Instance. While trying to see the Snapshot Agent status, I see this error. Failed to connect to Azure Storage ” with OS error: 53.
While configuring the Distribution wizard, I had the option to set the Snapshot folder as well as the Storage account connection string.
I got the storage account connection string from the Azure Portal and pasted that in. I am in doubt about the Snapshot folder. What value should I set in there ?
Is it a folder inside Azure Storage account or in the Distributor SQL Server instance ? In the Distribution wizard, it said, that the details of the folder would also be in the Azure portal. Is there a place where I could get it ?
I am getting a feeling that if I have the correct setting for this, my snapshot replication would work just fine.
Can anybody guide me to find out the problem ?