<div>
<div class="content wysiwyg-content">
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.<br />
<br />
I want to setup the Report Services integration so we can run reports through the sharepoint site. <br />
<br />
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...<br />
<br />
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?<br />
<br />
Thanks.<br />
<br />

</div>
</div>


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?

Thanks.



Change Reporting Services Server mode from Native to Sharepoint integrated

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.