After installing Lync monitoring Server role you might face a problem when trying to open monitoring server related to CDRDB and QMSDB.
The CDRDB is the Data Source associated with the Call Detail Recording Database
and the QMSDB is the Data Source associated withe Quality of Service Database.
since the Lync reporting server uses Microsoft SQL Reporting Services for detailed reports generation, it seems this error is related to the user account that designated during the installation to connect to the SQL reporting Services. although usually the Lync installation wizard verifies the user account supplied during installation and will not continue the setup if there was something wrong with the information supplied.
in this case the installation process will complete successfully without any errors.
The Lync Server uses by default a windows user account to connect to the Data Sources that are associated with Call details recording and Quality of Service databases.
In order to modify the settings for those data sources we should access the reports configuration as below
(remember to use access the reports using http since if https is already configured for reportServer Access thus it will not work)
we need to change the configuration for both CDRDB and QMSDB that is located under the “lync_ServerReports\Reports_content\” folders
now we can have access to the data source configuration.
Access each data source configuration and scroll down to the bottom section where you find the user account that you used for reporting services during the installation
notice the notification in read at the bottom
after changing the information for both the CDRDB and the QMSDB close internet explorer and login to the monirtoring server by using the following link https://monitoringServerFQND/ReportServer using valid administrative account. ( I use the same account that is used to log on to the Lync control panel )
browse the dashboard under the lync server reports you should be able to open it successfully.