Associate Monitoring Reports with a mirror database in Skype for Business Server
Summary: Learn how to associate Monitoring Reports with a mirror database used by Skype for Business Server.
Monitor reports with a mirror database
When you configure a mirror for your monitoring database that mirror database takes over as the primary database if a failover occurs. However, if you use Skype for Business Server Monitoring Reports and a failover occurs, you might find that your Monitoring Reports aren't connecting to the mirror database. This is because, when you install Monitoring Reports, you specify only the location of the primary database; you don't specify the location of the mirror database.
To get Monitoring Reports to automatically fail over to the mirror database, you must add the mirror database as a "failover partner" to the two databases that are used by Monitoring Reports (one database for Call Detail Record data, and the other for Quality of Experience (QoE) data). (This step should be performed after you install Monitoring Reports.) You can add the failover partner information by manually editing the connection string values used by these two databases. To do that, complete the following procedure:
Use Internet Explorer to open the SQL Server Reporting Services home page. The Reporting Services home page URL includes:
The http: prefix.
The fully qualified domain name (FQDN) of the computer where the Reporting Services is installed (for example,
atl-sql-001.litwareinc.com).The character string /Reports_.
The name of the database instance where the Monitoring Reports are installed (for example, archinst).
For example, if SQL Server Reporting Services was installed on the computer
atl-sql-001.litwareinc.comand the Monitoring Reports use the database instance archinst, the home page URL would look like this:http://atl-sql-001.litwareinc.com/Reports_archinst
After you access the Reporting Services home page, select ServerReports, and then select Reports_Content. That takes you to the Reports_Content page for the Skype for Business Server Monitoring Reports.
On the Reports_Content page, select the CDRDB data source.
On the CDRDB page, on the Properties tab, look for the text box labeled Connection string. The current connection string looks similar to this:
Data source=(local)\archinst;initial catalog=LcsCDR
Edit the connection string to include the server name and database instance for the mirror database. For example, if the server is named atl-mirror-001 and the mirror database is in the archinst instance, you need to add to specify the mirror database using this syntax:
Failover Partner=atl-mirror-001\archinst
Your edited connection string looks like this:
Data source=(local)\archinst;Failover Partner=atl-mirror-001\archinst;initial catalog=LcsCDR
After updating the connection string, select Apply.
On the CDRDB page, select the Reports_Content link. Select the QMSDB data source, and then edit the connection string for the QoE database. For example:
Data source=(local)\archinst;Failover Partner=atl-mirror-001\archinst;initial catalog=QoEMetricsSelect Apply.