How to: Create a Report Server Database (Reporting Services Configuration)

Reporting Services uses a SQL Server database for internal storage. The database is a required component; it is used to store reports, session data, resources, and server metadata.

If you installed Reporting Services in the default configuration, the report server database is created automatically when the report server instance is installed. However, if you performed a files-only installation, you must create the database after setup is finished. To create a report server database, you can use the Reporting Services Configuration tool.

  1. Start the Reporting Services Configuration tool and connect to the report server instance for which you are creating the database. For more information about how to connect to a report server instance, see How to: Start Reporting Services Configuration.

  2. On the Database Setup page, type or select the SQL Server Database Engine instance that you want to use. You can choose either a SQL Server 2000 or SQL Server 2005 instance. Not all editions can be used to host the database. For more information about edition compatibility, see Creating a Report Server Database.

  3. Click Connect. This opens a SQL Server Connection dialog box so that you can specify credentials have permission create a database on the server. Click OK to connect to the server.

  4. On the Database Setup page, click New. This reopens the SQL Server Connection dialog box.

  5. Type the name of the report server database. A temporary database is created along with the primary database.

  6. Choose the collation language to use, and then click OK.

  7. On the Database Setup page, in Credentials Type, specify the credentials used by the report server to connect to the report server database. For more information about the choosing different accounts, see Setting Up Windows Service Accounts and Configuring a Report Server Database Connection.

    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.
  8. Click Apply.