How to configure standalone SQL server, Database Mirroring, and Always on High Availability

How to configure standalone SQL server, Database Mirroring, and Always on High Availability

1. Prepare database connection strings as per SQL server configuration.

For the standalone SQL Server connection string:
"Server=;Initial Catalog=;Integrated Security=True"

For the database Mirroring connection string:
"Server=; Initial Catalog=;Integrated Security=True; Failover Partner="

For Always on High Availability connection string:
"Server=; Initial Catalog=;Integrated Security=True; MultiSubnetFailover=True"

2. Nullify all service DB connection strings.
3. Set all service DB connection strings.
4. Update all service connections strings accordingly.
5. Nullify Log and Monitor DataStore DB connection strings.
6. Set Log and Monitor DataStore DB connection strings.