I have a SQL Database in Azure, I have geo-replicated. I am simulating a failover by using the "force failover" in Azure.
One question , since the app service that connected to the primary has a connection that relies on the sql server that lives in North Central US ,like the following:

```
"Server=mynthcentralusserver.database.windows.net ....

```

When i create my secondary sql database backup it requires a server . I dont want to put the server in the same region as the primary (North Central US) as that region I am simulating is down, so if i create a sql server in South Central US , the connection string will obviously change to something like:

```
"Server=mysthcentralusserver.database.windows.net .... just the server part. 

```

So does that mean i need to manually go and change the app service configuration settings ?
Also if the primary location North Central US is back up and I want to move back there , do in I need to go back and change the connection string again to point to the server in North Central US ?