The data source connection information has been deleted.

Fri, 25 Jul 2008 22:14:43 Z

I was trying to fix my TFS sharepoint search capability and have now messed up my reporting services. Sharepoint works like a champ but I can't run any preexisting TFS reports, like Remaing Work. I get this error: "

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference). While fixing sharepoint, I changed user ids of some services in the IIS application pool. I don't know what I did wrong to mess up reporting. Thanx.

The data source connection information has been deleted.

Sat, 26 Jul 2008 11:05:32 Z

Hi topoli

I got 2 questions:

Do you see this error message for every reports or just one report?
Have you changed account for the application pools used by reporting service and team foundation server?

The data source connection information has been deleted.

Sun, 27 Jul 2008 01:42:19 Z

1. I see this error for all the errors.

2. Yes, I changed all the accounts to tfsservice in the application pool to be consistent, But found out this was a mistake ...

Thanx,

The data source connection information has been deleted.

Sun, 27 Jul 2008 11:17:17 Z

topoli

To change account used by TFS web services and Reporting Service, you can use TFSAdminUtil.exe. This command can assign the required permission to the new service account. Please try this command with ChangeAccount switch to change to the new service account. After this, you can run this command with ActivateAt switch to start TFS web services.

The data source connection information has been deleted.

Mon, 28 Jul 2008 07:25:08 Z

Hello topoli,

In addition to Bill's,

Please check the shared data source at the Report Service Site.

Here are brief steps,

1. Open the http://<ReportServer>/Reports

2. Please check if there are two shared data sources

a. TfsReportDS

b. TfsOlapReportDS

More in Data Sources for Team Foundation Reporting

3. If there is no such data sources, try to create them

a. Click 'New data sources' button.

4. Here are some properties of the TfsReportDS and TfsOlapReportDS data source

TfsReportDS :

Connection string : Data source=<Data-Tier Name>;initial catalog=TfsWarehouse

Connection type: Microsoft SQL Sever.

TfsOlapReportDS :

Connection string : Data source=<Data-Tier Name>;initial catalog=TfsWarehouse

Connection type: Microsoft SQL Server Analysis Services.

Please make sure Connect using : the Credentials stored securely in the report server setting.

And the credential is the TFSREPORTS account used during the TFS Setup.

If you have any question please let me know.

Good luck.

The data source connection information has been deleted.

Mon, 28 Jul 2008 16:54:43 Z

Thank you for your help. Here is what I did:

Tried to bring up a report and it gave me this error:\
- The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
I then, went into Properties -> DataSource
And saw this next to the Shared DataSource: The shared data source reference is no longer valid
I then browsed and selected TfsReportDS and TfsOlapReportDS at the root
And the reports work.
I did this for all my reports and everything is back to normal
But I am not sure why ? and if changing of the users in one of the IIS application pool is going to haunt me in the future ... Eventhough things look to be normal now

Thanx.

The data source connection information has been deleted.

Mon, 11 May 2009 11:15:28 Z

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