Recover or recreate ReportServer database for Dynamics 365

apollo7
apollo7 used Ask the Experts™
on
Windows 2012, SQL 2012, Dynamics 365

The ReportServer and ReportServerTemp databases, from our CRM 2011 SQL server, were restored to our Dynamics 365 SQL Server.  This did not work and made all reports in Dynamics 365 non-functional.

I have tried creating a new ReportServer database using the SQL Reporting Configuration Tool however this does not make the existing reports functional.

What is the solution to get back to where were before the  ReportServer and ReportServerTemp databases were restored from our CRM 2011 SQL server?

Is there a method to map the existing reports to the new ReportServer datasource I created?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
After rebuilding the ReportServer if the URL changed, you have to change it in Deployment Manager. Have you tried that?

Author

Commented:
The url didn't change, same in Deployment Manager

Rebuilding the reportserver seems to have eliminated all the connections to report
Chief Technology Ninja
Distinguished Expert 2018
Commented:
Did you reinstall reporting extensions?

Author

Commented:
No, will give that a try

Author

Commented:
Thank you sir, the problem is solved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial