Tag: Reporting Services

Reporting Services error 503: Error creating HTTP endpoint – Access is Denied

We had a case come in where they were seeing a blank page when they went to Report Manager for Reporting Services.  You may also see an HTTP 503 error.  This just means that the service had a problem and there was probably an exception that occurred under the hoods. In this case, the issue …

Continue reading

How to check permissions in Reporting Services programmatically

get-all-permissions-SQL-reporting-services

One day we found that we need to check users and groups permissions on SQL Reporting Services to understand who has access to what. So the next question is how to get all permissions in SQL Reporting Services programmatically and possibly export them to Excel for future analysis. After some time searching I ended up …

Continue reading

Cannot impersonate user for data source ‘CDRDB’. (rsErrorImpersonatingUser)

When deploying the Skype for Business Archiving and Monitoring role, it asks for a user account and password. Many clients don’t have a service account for this (or simply don;t understand they need a service account for this) and just put in the username and password of the Administrator or the person doing the install. …

Continue reading

Skype for Business Server 2019 Monitoring Reports Error: Cannot get the ReportServerWebService URL

When deploying a recent Skype for Business Server 2019 deployment, I came across an issue when installing monitoring reports on a server. In previous editions of SQL Server, SQL Server Reporting Services (SSRS) was installed and configured by default. With the release of SQL Server 2017, this is now a seperate download that only installs …

Continue reading