John Yassa's Blog

Home » Posts tagged 'Lync 2010 Monitoring reports problem'

Tag Archives: Lync 2010 Monitoring reports problem

The policy for ‘RTCUniversalServerAdmins’ user or group is not valid,when deploying Monitoring Lync Reports

When deploying Lync 2010 Monitoring Server Reports, i have faced the below error

The policy for ‘RTCUniversalServerAdmins’ user or group is not valid. The role assignment is either empty, specifies a user or group name that is already used in an existing role assignment for the current item, or specifies duplicate roles for the same user or group. —> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidPolicyDefinitionException: The policy for ‘RTCUniversalServerAdmins’ user or group is not valid. The role assignment is either empty, specifies a user or group name that is already used in an existing role assignment for the current item, or specifies duplicate roles for the same user or group.

1

 

The Log didn’t show anything that is helpful

So here what i have done to solve this issue:

1- Press the finish button in the attached screen

2- Open the URL of the Reports sites, you can get it from the SQL Server Reporting Configuration Manager as below
2

 

3- After browsing to the URL navigate to Lync ServerReports > Reports_Content you will see both of the data sources listed (CDRDB and QMSDB).  If you click on CDRDB you will get the properties for the data source: as below:
3\

4- Verify that in the Connection string: field the SQL server name and instance is correct.  In the example above, the connection string is pointing to the local SQL server that has SQL Reporting Services installed.  Change (local) to the correct SQL server and instance, enter the password for the account that you selected to connect to the Monitoring Server databases and click on Apply.

5- Now go back one step and click on QMSDB as below and repeat the same steps as step 4:
4

6- After that i was able normally to browse the Lync Monitoring reports without any problem as below
5

<span>%d</span> bloggers like this: