Sql-server – The report server cannot process the report or shared dataset

reporting-servicessql serverssrs-2008

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

Best Answer

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

Be sure you're on a version of IE this will not work correctly in Chrome
Go to your report server
Click on ... , on top-right of your report name
Click on 'Manage'
Click on 'Data Sources'
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 Solutions

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Report Builder 3.0 – Dataset Credentials Do Not Work

After much gnashing and wailing seems like Report Builder uses information in definitions in Report Server to then run queries locally by itself, and not through Reporting Services.

My mistaken belief was that when I did something like Refresh Fields when setting up a Dataset, Report Builder was going through Report Services to get the relevant output and/or metadata. This seems to not be the case.

I had defined the connection string of the shared data source as Data Source=(local);Initial Catalog=<database name>. Now, this works when you are in Reporting Services' browser interface, but Report Builder seems to read the connection string and use it for itself. Reporting Services on my local development machine does not have any of the setup on the target server running these reports, so anything I would use will fail.

Changing the connection string to Data Source=<server name>;Initial Catalog=<database name>, instead of localhost, allowed Report Builder to work properly. (RB still popped up "Enter Data Source Credentials". I used my Windows credentials, which is a valid login on the target server.)

Best Answer

Related Solutions

Sql – How to return only the Date from a SQL Server DateTime datatype

Report Builder 3.0 – Dataset Credentials Do Not Work

Related Topic