QUESTION POSED ON: 11 February 2006
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?
|