Hello all,
I am in a fix here. I run RS2000 on SQLSERVER2000, IIS6. My dev env is VS2003( .net 1.1). About 2 months back I deployed reports to an intranet site. They worked as expected. All of a sudden I get the folowing error:
- An error has occurred during report processing. (rsProcessingAborted) Get Online Help
- Cannot create a connection to data source 'XXX'. (rsErrorOpeningConnection) Get Online Help
- SQL Server does not exist or access denied.
- Cannot create a connection to data source 'XXX'. (rsErrorOpeningConnection) Get Online Help
The SQLSERVER exists and is up and running. I use SQL authentication which is fine. I can preview the report in dev env, from VS2003 but the server simply does not like. I can ping the SQLSERVER from the reporting server BOX, I created a test DSN as with the sql login I use for reports, test is successful.
I deleted the folder of reports and re-created, deployed all reports fresh --- does not help.
Any help is appreciated
rsProcessingAborted Error!!
wwwxwww
Here is another post that references the error message.
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=219964&SiteID=1
Did you try creating a simple report & pointing it to the data source Try creating the data source manually on the server and then changing the report to point to the new data source Creating the report under a different name
More options:
Try using the IP instead of the machine name.
Can you connect to SQL Server from the Report Server (or are they on the same machine )