Visual Studio report processing error
I developed an RS report in Visual Studio 2003 that accesses an external database located in our Windows 2000 Server domain controller. In my Windows XP Desktop, the report works fine when I test it in the preview option of VStudio. I deployed the report to a Windows 2000 Member Server, which is the Report Server. When I try to run the report from my desktop through the Report Manager (Internet Explorer), I get the following error:
An error has occurred during report processing. (rsProcessingAborted) - Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) - Specified cast is not valid.
If I run the report locally in the Report Server it works fine. MSDN has an article about database connection problems but it does not solve the question. Could you help me please?
You need to check the report manager to make sure the data source for the report is present. It's definitely a data source issue.
View questions and answers from all of our SQL Server experts here.
This was first published in March 2006