The report server cannot process the report or shared dataset

sql-server reporting-services ssrs-2008
lucasasecas picture lucasasecas · Jun 9, 2014 · Viewed 47.2k times · Source

I have a problem when I deploy my report project to a remote ssrs with the shared datasource. When I'm using the SQL Server data tool to "preview" my report, it's looks like have no problem. But when Y deply the project, this error message appear

The report server cannot process the report or shared dataset. The shared data source 'DataSource1' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)

noteworthy that the datasource it's pointing to the remote database

Answer

Tanner_Gram picture Tanner_Gram · Jun 9, 2014

If you are using a report server, then perform the following steps:

  1. Be sure you're on a version of IE this will not work correctly in Chrome
  2. Go to your report server
  3. Click on ... , on top-right of your report name
  4. Click on 'Manage'
  5. Click on 'Data Sources'
  6. Make sure that Connect to: settings are pointing to the right places.

You would be amazed how many times this will happen because of a credentials issue or how the data source is setup. In the same case share data source will be in a different folder than the initial one. Maybe you will see a warning label.

Without more information about what kind of server you are using, this is all I can think of suggesting.

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element: <Report …

Read More
SSRS 2008: error message saying my parameter doesn't exist but it clearly does?

I have a report that has about 10 parameters and about 10 datasets and one datasource. I typed alot but I really need help so I figured I would try and provide as much info about the problem as I could right …

Read More