John Yassa's Blog

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

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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: