How to find or view the conrtent of a datasource in a report in SQL 2005

Question

Dear all,

I'm very new to SQL 2005 & recently I'm assigned to modify an existing report. Viewing code from that report, I have the following:

<

Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<

DataSources>

<

DataSource Name="SQL2_ETM">

<

rd:DataSourceID>d345bf29-d2a1-497c-b322-44e3415a2f2e</rd:DataSourceID>

<

DataSourceReference>SQL2_ETM</DataSourceReference>

</

DataSource>

</

DataSources>

At this time, I've tried myself (because the person who created that report already left, so I have no clues) to search a query or any thing named "SQL2_ETM", but I couldn't find it. Please advise me!

Thanks so much,

Ed

Answer 1

you should have a file called SQL2_ETM.rds.

With which software are you editing your reports? BIDS or Report Builder?

Answer 2

Hi DaxRider,

Thanks for your reply! I'm using BIDS. I tried to search all partitions I can access into, but not successfull! When I go to Report Manager & go to the report I want to find its datasource, Properties > Dat Sources, it displays a message next "The share data source reference is no longer valid".

Answer 3

Well the error message seems to say it all: the shared datasource must have been deleted.

What you can also try: connect to your reporting server and check there if you can find any datasources named SQL2_ETM.
If you dont know how it's done: just go to your internet browser and type the address http://your-server-ip/reports the login and look in the directories for datasources.

Answer 4

Hi DaxRider,

Thanks for your help!

After spending a lot of time trying ... Now I know why I got the error message "The share data source reference is no longer valid" in Report Manager of SQL Server Reporting Services. One cause may be, as DaxRider mentioned, the data source may be deleted. Another cause may be, in my case, not log-into the appropriate server. More details, the in-house application reports are set up on the sql server of the server, let say "Server 01". So, instead of logging into the Sever 01, I always logged into another server, let say "Server 02" in the past (because I know I can run SQL server on that server - Server 02). Therefore every time going to the Report Manager on the Server 02, I got the above error message. But when I logged into the right server, Server 01, the erros message doesn't appear & now I can browse & select a datasource for that report.

Frankly saying that I don't really know the truth reason that trigged the error message (in my case): maybe as what I thought above, or maybe lack of permission on the Server. Please correct me!

Thanks

Ed