Database Setup (Reporting Services Configuration)
Use the Database Setup page to create and configure the report server databases that provide internal storage for one or more report server instances. Creating a report server database and configuring the connection is a multi-step process. It is important that you follow all the steps:
- Specify the SQL Server Database Engine instance and click Connect.
- Select, create, or upgrade a report server database. Click New to create a new database. To use an existing database, choose it from the list. Click Upgrade if the existing database is from a previous installation.
- Assign permissions and create a login used for the database connection. These steps are performed by the tool and occur when you click Apply. You can monitor the status of steps 2 and 3 in the Task Status pane. Be sure to scroll to the end of the messages to verify that all steps were completed successfully.
A report server database must support a specific server mode. The default mode is native mode, but you can also create a report server database for SharePoint integrated mode if you are running a report server in a larger deployment of a SharePoint product or technology. For more information, see How to: Create a Report Server Database (Reporting Services Configuration) and How to: Create a Report Server Database for SharePoint Integrated Mode (Reporting Services Configuration).
If you are using SQL Server 2005 Express Edition with Advanced Services, you must use the local SQL Server Express Database Engine instance to host the report server database. If you are creating a report server database on an instance of SQL Server that has been upgraded from version 7.0, you might need to set the database compatibility level before you create the database. For more information, see Reporting Services in SQL Server 2005 Express Edition with Advanced Services and How to: Configure a Report Server Database on a Database Engine Upgraded from SQL Server 7.0 (Reporting Services Configuration).
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.
- Database Version
Identifies the version of the SQL Server Database Engine instance that hosts the report server database.
- Server Mode
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.
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 SQL Server Connection Dialog 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.
- Credentials Type
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.
- Account Name
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.
12 December 2006
Upgrading a Report Server Database
Upgrading a Default Installation of Reporting Services
How to: Create a Report Server Database (Reporting Services Configuration)
Report Server Database
Configuring a Report Server Database Connection
Administering a Report Server Database
Configuring a Report Server Scale-Out Deployment