Problem with sqlreportviewer and multiple SSRS datasources

4 replies. Last post: August 10, 2012 12:01 AM by Handy Surya
Tags :
  • (None)
  • New Discussion
  • New Question
  • New Product Feedback
SumnerMember

I have a really strange problem with the sqlreportviewer control.

If I only have one datasource in reporting services, sqlreportviewer behaves exactly as expected.

For example;

I start with a completely new SSRS database

Add a single datasource called DataSourceA pointing to database A

Add a report called ReportA that uses DataSourceA

Run Report A from using sqlreportviewer and everything seems fine (report appears with data - no errors)

NOW THE WEIRD BIT

Add a new data source in SSRS called DataSource B pointing to Database B

Go back and run Report A and I get a security error telling me I cannot open Database B

Nothing else has changed except the addition ofi DataSource B

This is driving me mad and I have double/treble checked all the settings for the report renderer atc etc (and I don't believe it is this because the report initially works)

Why is sqlreportviewer trying to access DataSource B when absolutely nothing has told it to do so?

Any ideas? 

All times are GMT -5. The time now is 1:07 PM.
Previous Next