Connect to High-Availability and Cloud Databases

For high availability and redundancy, you can set up the Privileged Identity program database using mirrored databases, database availability groups (SQL AlwaysOn), or Azure SQL.

To access database settings, select Settings > Data Store Configuration > Basic Configuration from the management console. If you change any database settings, you must restart the deferred processor. You must also update the web app configuration:

  1. Select Manage Web App from the left action pane of the management console.
  2. Right-click the web site instance.
  3. Select Replace instance options with default web application options.

The sections below give details for setting up specific database configurations. For instructions about fields that are non-specific to these configurations, please see Set Up the Program Database.

Mirrored Databases

Database Data Store Configuration - Mirrored Databases

To connect to a mirrored instance of Microsoft SQL Server, make the following specific configurations:

  • Database access - Select ODBC Driver: SQL Server Native Client. You must also manually install this provider on all web app servers, web service servers, and deferred and zone processor hosts. Otherwise, they will be unable to connect to the database.
  • Server name - Enter the name of the primary (currently active) database partner.
  • Add additional connection string parameter - Modify the following parameter with your mirrored server name:

    Failover_Partner=SECONDARY_SERVER_NAME;

  • Click Update near the bottom of the screen, and review the updated connection string.

SQL AlwaysOn

Database Data Store Configuration - SQL AlwaysOn

To connect to a SQL Server database configured using SQL AlwaysOn, make the following specific configurations:

  • Database access - Select ODBC Driver: SQL Server Native Client. You must also manually install this provider on all web app servers, web service servers, and deferred and zone processor hosts. Otherwise, they will be unable to connect to the database.
  • Server name - Enter the name of the availability group listener (AGListener), prefaced with the protocol. For example:

    tcp:AGListenerName

  • Add additional connection string parameter - Add the following connection string parameter:

    MultiSubnetFailover=True;

  • Click Update near the bottom of the screen, and review the updated connection string.

Azure SQL

Database Data Store Configuration - Azure SQL Database

To connect to a SQL Server database configured using Azure SQL, make the following specific configurations:

  • Database access - Select ODBC Driver: SQL Server Native Client. You must also manually install this provider on all web app servers, web service servers, and deferred and zone processor hosts. Otherwise, they will be unable to connect to the database.
  • Server name - Enter the name of your Azure SQL instance, prefaced with the protocol. For example:

    tcp:servername.database.windows.net

  • Click Update near the bottom of the screen, and review the updated connection string.