Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to know more about the data-driven subscriptions on our ReportServer. I am specifically looking for what shared data sources are being used, but the connection string would also suffice.

I have poked around the Subscriptions and DataSource tables, but nothing seems to give me the information I need. Any ideas?

share|improve this question
up vote 1 down vote accepted

I kept poking around and... found it. For the future reference of others:

, Subscriptions.[Description]
  join DataSource
    on Subscriptions.SubscriptionID = DataSource.SubscriptionID
  join Catalog
    on DataSource.Link = Catalog.ItemID
share|improve this answer
Thanks for adding your own solution! Don't forget to accept it if it solved your case. – Jeroen May 2 '12 at 21:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.