Specifies the name of the SQL Server Database Engine that runs the report server database.

You can use a SQL Server 2000 or SQL Server 2005 instance. You can use a default or named instance on a local or remote computer.

If you are connecting to a named instance, enter the server name in this format: <server>\<instance>.

If you are connecting to a remote instance, you might need to enable that instance for remote connections. Some versions of SQL Server 2005 do not enable remote connections by default. To confirm whether remote connections are allowed, use the SQL Server Surface Area Configuration tool and view the Remote Connections setting of the target instance. If the remote instance is also a named instance, verify that the SQL Server Browser service is enabled and running on the target server. SQL Server Browser provides the port number that is used by the named instance to the Reporting Services Configuration tool.

Click Connect to log on to the SQL Server Database Engine. The SQL Server Connection dialog box opens so that you can specify credentials used to log on to the server. You can use your credentials or specify a SQL Server login.

Specifies the name of the report server database that stores server data. You can specify an existing database or create a new database.

Choose an existing database if you are upgrading or migrating a Reporting Services installation. Only databases that contain the report server tables are available to choose.

If you choose a report server database that was created using the SQL Server 2000 version of Reporting Services, you can upgrade the database to the new format.

Identifies the version of the SQL Server Database Engine instance that hosts the report server database.

Indicates whether the report server database supports native mode or SharePoint integrated mode. The server mode that you specify determines the structure of the report server database and sets the SharePointIntegrated report server property to true. For more information, see Deployment Modes for Reporting Services.

Click New to create a new database on the SQL Server instance to which you are currently connected. The SQL Server Connection dialog box opens so that you can specify credentials that have permission to create a new database on that server.

The Reporting Services Configuration tool creates two databases that are bound by name: a database to contain static data and a temporary database for storing session and work data.

Click Upgrade to migrate the tables to the new database schema. The database is upgraded in place. Upgrading the database is required if you want to use it with a SQL Server 2005 Reporting Services instance.

Note:
After you upgrade a report server database, you cannot roll it back to a previous version. Be sure that you have a backup of the database before you upgrade it.

Opens the SharePoint Database Change dialog box so that you can create a new report server database in SharePoint integrated mode.

When you create the database, the SharePointIntegrated server property is set simultaneously.

Specifies credentials that the report server uses to connect to the report server database. For more information about choosing credentials, see Configuring a Report Server Database Connection.

Specifies a domain user account if you are using Windows credentials or a SQL Server login if you are using SQL Server credentials. If you are using Windows credentials, specify them in this format: <domain>\<account>

Specifies the password for the account.

Click Script to create SQL script (.sql) files for future use in a scripted environment. You can create scripts to create and upgrade a report server database to the current schema. You can also create and run a script that configures the SQL Server database roles for the account(s) used to connect to the report server database.