I currently have Reporting Services running on SQL 2005 in a production environment. I have an intranet setup on a separate server that is running Sharepoint Services 3.0.
I want to setup the Report Services integration so we can run reports through the sharepoint site.
Reporting Services is running in Native Mode. In order to setup the integration, I need to change it from Native to Sharepoint integrated within the Reporting Services Configuration tool...
If I make that change, do all of my reports and users and settings copy over? Or do I need to recreate everything from scratch?