Share via

SQL failover

satyam mehrotra 21 Reputation points
2021-07-28T11:13:45.797+00:00

Hi Guys, I have a in-house server running multiple applications which uses MSSQL as a DB. I have two public IPs. I have purchased a failover service from Azure, so when my one ISP goes down, it points the traffic to another. The problem is when one ISP goes down my apps hosted on IIS works properly, SQL doesn't work because we can define only one IP on Web.config. Is there any workaround? So that when one ISP fails my SQL also switches to active ISP IP?

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-07-29T06:42:06.603+00:00

    Hi @satyam mehrotra ,

    > I have purchased a failover service from Azure

    What did this mean? SQL server always group or SQL server cluster instance?

    If you want to configure SQL AG on a Multi-Subnet Cluster or two subnet SQL failover cluster instance (FCI) , please refer to below links to get detail steps information.

    Configure SQL Server Always On Availability Group on a Multi-Subnet Cluster
    SQL Server Multi-Subnet Clustering (SQL Server)

    If you mean one SQL server instance with two public IP addresses, please check the solutions from the old thread How to allow connections to SQL Server with 2 different IP.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.