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.

Tasks

Reference

Concepts

Other Resources