Geo Replication RRS feed

  • Question

  • I have set up an Azure database instance which replicates into a 'read only' secondary database using standard geo-replication. In the Azure portal I can see the status of the primary server as online and for secondary it is readable So, the issue is when i am trying to login to the secondary database server using SSMS then error somes stating "Cannot open server requested by login". Please help me to login replicated database through SSMS.
    Friday, September 9, 2016 10:47 AM

All replies

  • Hi ,

    have you check the firewall ip policy of azure database ?


    Friday, September 9, 2016 5:14 PM
  • In addition to enabling the firewall rules please make sure to follow the security guidance in this article . It covers both secondary access and new primary access after failover.
    Monday, September 12, 2016 5:31 PM