How to: Create a Report Server Database for SharePoint Integrated Mode (Reporting Services Configuration)

Use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode and configure the connection from the report server to the report server database. Only the report server connects to the report server database. The Windows SharePoint Services or Office SharePoint Server instance that you are integrating the report server with never connects to or retrieves data from the report server database directly.

A report server database can support native mode operations or SharePoint integration mode, but not both. If you create a report server database to support SharePoint integrated mode, you cannot convert or migrate the database to run with a native mode report server instance later. The report server database contains mode-specific metadata (specifically, item location, and permission information) that is not compatible in the other mode.

When created for SharePoint integrated mode, the report server database stores server properties, report execution snapshots, report history, subscription definitions, and schedules. It stores a secondary copy of reports, report models, shared data sources, and resources to improve processing performance on the server. Primary storage for report documents is in the SharePoint content databases. For more information, see Storing and Synchronizing Report Server Content With SharePoint Databases.

Key points to remember about a report server database that supports SharePoint integrations include the following:

  • Use the Change Database Wizard in the Database page of the Reporting Services Configuration tool to create the report server database in SharePoint integrated mode. For instructions, see How to: Create a Report Server Database (Reporting Services Configuration).

  • Use the Reporting Services Configuration tool to maintain or update the connection information to the report server database.

  • Use SQL Server Management Studio and SQL Server tools to back up and administer a report server database. The database backup features in SharePoint 3.0 Central Administration do not apply to a report server database.

  • Creating the report server database is only one step in a multi-step process that configures a report server for integration operations. After you create the database, complete the integration steps by starting SharePoint 3.0 Central Administration and specifying the report server integration settings. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration.