Error while viewing the Report in report manager URL

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  March 13, 2009 at 11:36 am

  #201561

  Hi,

  I created a report in BIDS from my local machine and deployed to C:\Documents and Settings\Visual Studio 2005\Projects\Report Project1\Sample1. Then I opened the Reporting services serevr URL

  http://ABC\reports ->Upload files->choose the rdl (Sample.rdl)file from above location.Here when I try view the report, Iam getting the below error:

  An error has occurred during report processing.

  Cannot create a connection to data source 'TESTDB'.

  For more information about this error navigate to the report server on the local server machine, or enable remote errors

  Please help me what should I do here

  thanx

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  March 13, 2009 at 4:10 pm

  #959529

  Sounds like you didn't deploy the datasource to the server. Either deploy (the entire project, which will include the DS, with a default to not overwrite it) via BIDS, or, using Reportmanger application, add a new datasource named TESTDB.

  hth,

  Steve.