Unable to Add Hub database to SQ"L Azure Sync Group

Question

Hello

I keep getting message "Could not connect to the database. Please ensure all fields are correct" when adding or testing connection to my server. Both Server & Database NAme dropdowns were empty.

I have tried for server name:-

tcp:nfv3nao0of        tcp://nfv3nao0of    and    nfv3nao0of

Also I assume Databse name is a new name to give it so I have entered for examplke ABCSG1Hub

I know my UserID & Password are corrct.

What is wrong please?

Answer 1

PS I have the firewall setting set to allow other Azure service

Answer 2

the database you are connecting to must be existing already.