question

satyammehrotra-9653 avatar image
0 Votes"
satyammehrotra-9653 asked Cathyji-msft commented

SQL failover

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @satyammehrotra-9653,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @satyammehrotra-9653,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.