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
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.
I Tried this Solution :-
Deploy All Data Sources and reports to report server once again.
This solution solve my problem
I was able to bulk update and fix the problem by updating the data source link using the T-SQL below.
begin tran
update dbo.DataSource
set Link = c.ItemID
from dbo.DataSource ds
inner join dbo.Catalog c
on ds.Name = c.Name
and c.Type = 5
where ds.link is null
select ds.Link oldlink, c.ItemID
from dbo.DataSource ds
inner join dbo.Catalog c
on ds.Name = c.Name
and c.Type = 5
--where ds.link is null
select *
from dbo.DataSource ds
where ds.link is null
rollback tran
-- commit tran
http://tsqlblog.blogspot.co.uk/2011/05/rsinvaliddatasourcereference-on.html
Initially I used a Datasourse that pointed to a local DB. When I create a remote ssrs and redply the project on server, I change manually the shared datasource.
Like I use a shared data source, every report has link to this shared datasource. The problem is that this link point to a old version of the datasource.
to solve the problem I refresh the link to the new datasource
