To switch to native mode
Click Start, point to Programs, point to Microsoft SQL Server 2008 R2, and then point to Configuration Tools.
Click Reporting Services Configuration. The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.
In Machine Name, specify the name of the computer on which the report server instance is installed. The name of the local computer is specified by default, but you can also type the name of a remote SQL Server instance.
In Instance Name, choose the SQL Server Reporting Services instance that you want to configure.
Click Connect.
Click Database Setup to open the Database Setup page. The page contains information about the database currently in use. The Server Mode should be set to SharePoint integrated.
Click Change.
Click OK to confirm that you want to create a new database.
In the SQL Server Connection dialog box, enter a name for the new database.
Verify that the Create the report server database in SharePoint integrated mode check box is not selected.
Click OK.
On the Database Setup page, specify the credentials that are used to connect to the report server database.
Choose Service credentials to use the Windows service account and Web service account to connect through integrated security.
Choose Windows credentials to specify a domain user account. A domain user account must be specified as
\ . Choose SQL Server credentials to specify a SQL Server login.
Click Apply.
When you switch from a SharePoint integrated report server to native mode, the location of the content and the permissions used to control access to the content is redefined. Content must be republished to the report server, you must assign roles on the report server that grants access to items and operations, and you must redefine subscriptions and scheduled operations. Report history that you created on the report server that ran in SharePoint integrated mode cannot be recreated on a native mode report server.
