Skype for Business Setting Up Rights Monitoring Server

2017-06-12 1 min read Skype for Business SQL Server Erwin Bierens

In order to give some people read only rights to the monitoring reports we’ll need to setup some settings in SQL Reporting. Go with Internet Explorer to your monitoring server webpage: http://sql01/Reports/ (Replace sql01 with your host).

SQL Report Settings

Click Manage to access the settings page for the LyncServerReports database. On the left side you will find Security, Click on it.

SQL Report Settings Security

Now click on the Add group or User. You have to options to enter:

Use Security Group (via Active Directory)
Use a specific User

In my case i’ve made a new group in Active Directory (i don’t want to give the user also right in Skype for Business Control Panel).

Make sure you’ll add the user who needs to view reports to the group ;-)

Active Directory Security Group

Let’s add the Group name in SQL Reporting.

SQL Reports Security Rights

Copy the AD Group name in the field. Select Monitoring Reports Browser as role. With this role it’s only possible to view. Click OK.

Now login as the user and try to reach the monitoring URL: http://sql01/ReportServer/Pages/ReportViewer.aspx?%2fLyncServerReports%2fReports+Home+Page

sfb monitoring reports