Azure geo-replication: Can't create a secondary server

Question

I have an Azure SQL data base on a premium tier I try to activate Geo-replication on the preview portal.

I clicked Server name on CREATE SECONDARY blade I then selected CREATE A NEW SERVER on SERVER blade I filled the form, but the OK button still stay disabled

Bellow is a screen copy:

What should I do more?

enter image description here

In which location your primary server is? Is it upgraded to V12 too? That is the only thing that can go wrong based on the UI .. — Sirisha Chamarthi, May 04 '15 at 06:22
i tried unsuccesfully different locations. But I discovered it's working fine when setting "create V12 server" at NO. I don't understand why this option is avalable if not working — Frédéric De Lène Mirouze, May 05 '15 at 16:04
Hi Frederic , can you try to do this again? and let me know if this issue is still occurring? I sent you and email regarding this question @ amethyste16 [at] Hotmail [dot] com — Boboyum, May 05 '15 at 23:43
The expectation is both primary secondary servers are of same type (SQL V12) or pre V12 I believe. — Sirisha Chamarthi, May 06 '15 at 06:14
@Boboyum I tried again. OK button is OK now (what did you change?). But the wizzard breaks later now. I can see the animation, but 10 seconds later it stops and does not create the geo-replication relationship — Frédéric De Lène Mirouze, May 06 '15 at 10:42

score 0 · Accepted Answer · answered May 07 '15 at 20:26

0

I had some exchange with a guy from Microsoft. This is the situation:

OK button works now (I don't know what they did)
But later the Geo replication fails

This is due to the fact that Azure thinks my server name is already in use. This is true I used it once, but I also delete it and it is not displayed on the SQL server blade.

So there is still an issue in the portal to be clarified and fixed. But everything works fine if I am using another server name.

answered May 07 '15 at 20:26

Frédéric De Lène Mirouze

545
5
25

Azure SQL DB Servers need to be unique. That said, we acknowledge that there is work to be done on the pre-validation of server names to ensure uniqueness before the portal allows the user to proceed. – Boboyum May 08 '15 at 16:41

Azure geo-replication: Can't create a secondary server

1 Answers1