Link to home
Start Free TrialLog in
Avatar of curiouswebster
curiouswebsterFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of curiouswebster

ASKER

thanks