SharePoint and SSRS: The given key was not present in the dictionary

Consider this scenario. You have SharePoint with SQL Reporting Services (SSRS) running in SharePoint Integrated mode. You want to use a SharePoint list as a data source for a report. In the SSRS Data Connection you enter the URL and credentials for the SharePoint site but when you test the connection the following error appears: The given key was not present in the dictionary After … Continue reading SharePoint and SSRS: The given key was not present in the dictionary

Changing SSRS database names

I’ve been working on a project where multiple servers including two SharePoint farms running SQL Server Reporting Services (SSRS) in SharePoint Integrated mode need to be moved to a single SQL Server. Each farm has its own SQL Server to host the SharePoint and SSRS databases. To make the job a little more challenging the databases in each farm have the same name. To complete … Continue reading Changing SSRS database names