How to: Switch Server Modes (Reporting Services Configuration)

If you configured a report server to run in SharePoint integrated mode, you can detach the report server from a deployment of a SharePoint technology instance by switching the server to native mode.

To switch modes, you point the server to a native mode report server database. You do not have to re-install the report server to switch modes.

Although you can switch the mode for the report server, you cannot switch the mode for the report server database. A report server database contains mode-specific data that is unusable in different context. If you created a report server database in SharePoint integrated mode, you cannot use it with a native mode report server.

There are three ways to switch from SharePoint integrated mode to native mode. From the Reporting Services Configuration tool, in the Database Setup page, do one of the following:

  • Click Change and create a new database.

  • From the list of existing databases, select an existing report server database that already runs in native mode, specify credentials, and click Apply.

  • Click New and create a new database. Be sure to clear the Use the schema that supports SharePoint integrated mode check box.

This topic provides steps for the first approach. For more information about how to configure a native mode report server to run in SharePoint integrated mode, see Configuring Reporting Services for SharePoint 2010 Integration.

To switch to native mode

  1. Click Start, point to Programs, point to Microsoft SQL Server 2008 R2, and then point to Configuration Tools.

  2. 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.

  3. 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.

  4. In Instance Name, choose the SQL Server Reporting Services instance that you want to configure.

  5. Click Connect.

  6. 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.

  7. Click Change.

  8. Click OK to confirm that you want to create a new database.

  9. In the SQL Server Connection dialog box, enter a name for the new database.

  10. Verify that the Create the report server database in SharePoint integrated mode check box is not selected.

  11. Click OK.

  12. On the Database Setup page, specify the credentials that are used to connect to the report server database.

    1. Choose Service credentials to use the Windows service account and Web service account to connect through integrated security.

    2. Choose Windows credentials to specify a domain user account. A domain user account must be specified as <domain>\<user>.

    3. Choose SQL Server credentials to specify a SQL Server login.

  13. 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.