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

SQL Server Setup

New: 12 December 2006

Use the Reporting Services Configuration tool included with SQL Server 2005 Service Pack 2 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.

There are three steps to creating the report server database:

  • Connect to the Database Engine instance that hosts the database.
  • Enter a name for the database, select a check box for SharePoint integrated mode, and create the database.
  • Specify credentials for the report server connection to the database.

Be sure to perform all three steps before you click Apply.

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: Set Report Server Integration in SharePoint Central Administration.

To create a report server database in SharePoint Integrated Mode

  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, 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.

    If you specify a remote computer, click Find to establish a connection. The report server must be configured for remote administration in advance. For more information, see Configuring a Remote Report Server Instance in SQL Server Books Online.

  4. In Instance Name, choose the SQL Server 2005 Reporting Services instance that you want to configure. Only SQL Server 2005 report server instances appear in the list. You cannot configure earlier versions of Reporting Services.

  5. Click Connect.

  6. Click Database Setup to open the Database Setup page.

  7. Enter the name of the SQL Server Database Engine you want to use.

  8. Click Connect.

  9. Click New.

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

  11. Select the Create the report server database in SharePoint integrated mode check box.

  12. Click OK.

  13. 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.
  14. Click Apply.

  15. Restart the Report Server Windows service.

See Also