Skip to main content

Enable Remote Errors in SQL Server Reporting Services 2005

Enabling remote errors in SQL Server Reporting Services 2005 (SSRS) By default, reporting services returns the following error message when a report produces an error: An error has occurred during report processing. Cannot create a connection to data source ‘AdventureWorks’. For more information about this error navigate to the report server on the local server […]

Moving Reporting Services 2005 using RSConfig

Moving Reporting Services 2005 database from one SQL Server Instance to another The development environment I’m currently working in uses two servers. IIS with Reporting Services 2005 on box1, and SQL Server 2005 on box2. For whatever reason, I was unable to get Reporting Services to install correctly on box1 with box2 as the SQL […]