How to install an additional hybrid join string in Azure
I have successfully configured Hybrid Connection to connect my Azure web app to my on-premises SQL Server. I added a line of primary network gateway , and it is listed with the command: Get-HybridConnection
.
However, he does not always stay in touch. Now I'm wondering what to do with the secondary connection string. If I try to add it using Add-HybridConnection
, I get this error:
Add-HybridConnection: existing configuration Endpoint = Hc: //xxxx.hybrid.biztalk.windows.net/xxxxx; SharedAccessKeyName = defaultListener; SharedAccessKey = XXXXXXX found.
Thus, you cannot add both primary and secondary connection strings to the same local hybrid connection manager . Should I install a different hybrid connection manager on a different server and install it with a secondary connection? I have tried this and it seams to work (the connection is held up when I stop one of the services), but I cannot find information on this.
I am also wondering when to click on the Primary Sync Key or the Secondary Sync Key on the Azure Portal.
source to share
Only one connection string can be synchronized at a time. [e] (from standalone application or hcm) [/ e]
When you press "Sync [Primary / Seconary] Key" it tells the stack to use the secondary key.
You would use this if you need to restore one of the keys, but still keep the HC up and running.
source to share