curiouswebster
asked on
SSRS: My Data Source no longer has any dependent items ???
I made a huge mistake and tried to copy an existing RDL and must have clicked the OK button as it was trying to set up a new connection...
Then I tried to see the management form for the page and pushed F5. This broke al the reports on our QA machine.
Now, i get a database error and none of the hundreds of reports are associated with a valid data source.
I get:
An error has occurred during report processing.
Cannot create a connection to data source 'MyDataSource'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
How do I force the existing reports to use a given Data Source?
Thanks.
Then I tried to see the management form for the page and pushed F5. This broke al the reports on our QA machine.
Now, i get a database error and none of the hundreds of reports are associated with a valid data source.
I get:
An error has occurred during report processing.
Cannot create a connection to data source 'MyDataSource'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
How do I force the existing reports to use a given Data Source?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER