Problem solve Get help with specific problems with your technologies, process and projects.

Visual Studio report processing error

SQL Server expert Eric Brown sheds light on an error message received when trying to run a Visual Studio report in Windows.

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.

Dig Deeper on SQL Server Business Intelligence Strategies

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.