Topic Last Modified: 2010-07-18
Monitoring Server requires the Microsoft SQL Server database software to store the collected Quality of Experience (QoE) and Call Detail Recording (CDR) data. Monitoring Server describes this data using a standard set of reports that are published by SQL Server Reporting Services. To view the reports, you must also install an instance of SQL Server Reporting Services.
You must install Microsoft SQL Server on the computer that will host the Monitoring Server database. This can be the same computer that runs Monitoring Server, or a dedicated database server. For best performance, you should deploy the Monitoring database to a computer that is separate from the Communications Server Central Management database.
Communications Server 2010 supports the following 64-bit versions of SQL Server:
- Standard or Enterprise Edition of SQL Server 2005 with Service
Pack 3
- Standard or Enterprise Edition of SQL Server 2008 with Service
Pack 1
Note: |
---|
SQL Server Express Edition is not supported. |
You should install the version of SQL Server Reporting Services that matches the installed version of SQL Server. For details about SQL Server, see SQL Server TechCenter. For details about SQL Server Reporting Services, see Considerations for Installing Reporting Services.
If you do not configure the Report Server while installing the Reporting Services, you will need to use the Reporting Services Configuration tool to configure the options that are required to run the Report Server after installation is complete.
For more information, see Reporting Services Configuration Tool and Reporting Services Configuration How-to Topics.
Verifying the Web Service URLs
After deploying Reporting Services you need to verify that the Reporting Services Web Service URLs, used to view the Monitoring Reports, are working correctly. You will be given the option to use either http or https to deploy reports. If both are available, Reporting Services will be installed to https.
For more information, see How to: Verify a Reporting Services Installation.
To verify if the URLs work-
Open Reporting Services Configuration Manager from the SQL Server Configuration Tools.
-
Connect to your instance of Reporting Server.
-
On the Web Services URL page, click the URLS listed under Report Server Web Service URLs to verify that the link can be opened.
You will deploy Monitoring reports to this link using the steps described in Deploying Monitoring Server Reports.