Installing Microsoft SQL Server 2012 Reporting Services

The Lync Server 2013 Monitoring server leverages Microsoft SQL Server Reporting Services to provide rich reports related to usage and quality of experience data. This section assumes you’ve already installed SQL and are familiar with the process. Small installations that chose to use the Enterprise edition of Lync Server 2013 can use the same SQL Server as the Front End pool; however, most larger deployments require a separate SQL Server and, in very large installations, a separate SQL Reporting Services server. In the steps that follow, you’ll walk through the installation process and post-installation steps for SQL Reporting Services.

During the SQL Server 2012 Installation Wizard, ensure that the Reporting Services box is checked and continue through the wizard. Be sure to examine the scalability requirements for your environment to determine whether the reporting services role should be placed on the SQL database server or on a dedicated serve. The administrator must also decide where to install the Reporting Services database, either on an existing SQL server or on the Reporting Services server. In general, it is recommended to collocate the Reporting Services database on the Reporting Services Server. After the SQL Reporting Services role is installed, it needs to be configured before the Monitoring Server can use it.

From the Start Menu, navigate to All programs, Microsoft SQL Server 2012, Configuration tools and select Reporting Services Configuration Manager. Ensure that the appropriate server and instance are selected and click Connect. To finish installing the Monitoring Components, follow these steps:

1. Click the Server Account button in the left column and set the appropriate report server service account.

2. Click the Web Service URL button. Review the settings. Usually the default settings are acceptable. However, if you want to use SSL, you’ll need to pick the certificate to be used. A certificate can be requested from the IIS console.

3. Click the Database button. Ensure that the proper database server is set. Ensure that the correct credentials are set to access the database.

4. Click the Report Manager URL button. Select the virtual directory to be used to access reports. By default, this is “Reports.”

Now the SQL Reporting Services server is almost ready. After the Monitoring server is installed, you’ll need to deploy the Monitoring Server Report Pack to the SQL Reporting Server as reviewed in the following text.