Error while deploying the report

I'm having a similar problem.

I downloaded the Microsoft example for Reporting off of Data cubes. This is located at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp

I unzipped everything, and it seems to work ... so long as I am inside the .NET 2003 studio environment. When I open the browser, it asks me to log in and then it tells me:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

Does anyone know what the problem is? I checked just about everything that I know how to...

JJ

Hi There,

I have the same problem. When i deploy/run the report from the local report server with the created ODBC, i don't receive this error. The report generates and i'm able to export it.

When i access the report on the report server from a remote PC (client PC), i receive the same error.

• The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

Any suggestions on how to get around this ?

Thanks,

Sonia

Using SQL Management Studio, expand the report that doesn't work, then Data Sources. Right click on the data source and click properties. Set the data source again. Somehow, when you deploy the reports, the server forgets what the Data Source should be.

For the deployment issues...

Make sure you have the correct URL where the report server lives. I have ran into this before and my problem was in the Solution Properties I had http:///ReportServer as my TargetServerURL. When I updated it to use the DNS name http://.com/ReportServer it worked fine.

For the other folks w/ the data source issues...

If you are using a browser other then IE or you are not connected to the network you will be prompted for your login credentials. This is to initially access the Report Manager site. Once in there if your data sources are set to use Windows Credentials I do not believe they will be able to connect if you are logged in remotely.

Hope this helps...

-Ben

I got the same error the first time I tried to deploy my RDLs to my local instance of SSRS.  The problem was indeed under my Project properties, I did not include the full path to the reporting server, which should be:

http://serveripordomainname/reportserver

That cleared it up for me.

Hi There,

I have the same problem.

I want to deploy my report.

I know that there are three possible way for deploying.....

1. Using the BI Development studio.

2. Using the SQL Server Management Studio.

3. Programmatically. [Using the RS.EXE utility]

I want to deploy my report Using the BI Development studio.

Now can anyone help me for this....

Please help me and tell all the required steps and condition....

PLease help 🙁

In case you have the message "The shared data source reference is no longer valid"

you can use the script below to recreate the data source reference. Success

DECLARE

@Link uniqueidentifier

SELECT @Link = ItemID FROM dbo.Catalog

WHERE Type = 6 -- Select the correct Datasource

BEGIN TRAN

UPDATE dbo.DataSource

SET Link = @Link

WHERE ItemID IN

(SELECT c.ItemID FROM dbo.Catalog c

INNER JOIN dbo.DataSource ds ON ds.ItemID = c.ItemID

WHERE c.type = 2 -- reports

AND ds.link is null

)

COMMIT TRAN

Thank you for the reply i was able to sort this out a while ago

I am getting this error "Select a shared data source.Specify a shared data source. The shared data source reference is no longer valid."

I don't have any information about the server and database what the report is pointing to.

Can anyone help me on to how to find the data source and server the report is pointing too..

I'm using the RSScripter and getting the same error. Does anyone have a fix for it?

Rather than do this programmatically there is an application (SSRS Data Source Manager) that can fix missing data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.

There is also a health check feature, to identify only reports and models that have missing data sources. Multiple data sources for reports and models are also supported.

http://www.lecomputing.com/ssrsdatasourcemanager.html

Other uses can be- changing a selection of reports to another data source, eg moving from UAT/Development to production, or server loading issues.