Support connecting to a different DNS listener for each of the Integrator's backend SQL databases
The Integrator currently supports only a single SQL server connection string to access all of its backend databases (PIIntegratorDB, PIIntegratorLogs, PIIntegratorStats). Our organization's SQL Server cluster provides high availability at the SQL database level, however, with a separate DNS listener for each database. When either of the other PI Integrator backend databases fails over to another SQL server, we see errors like the following:
“SqlUtilities:GetBackendSqlConnection: Error: Unable to obtain open SqlConnection to database, ‘PIIntegratorLogs’,at SQL server path, '(Server)'".