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 3.0 Integration.
To switch to
native mode
1. Click
Start, point to Programs, point to Microsoft SQL Server 2008, 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.
a. Choose
Service credentials to use the Windows service account and Web service account
to connect through integrated security.
b. Choose
Windows credentials to specify a domain user account. A domain user account
must be specified as \.
c. 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.
