Database (Reporting Services Configuration)

SQL Server Setup

previous page next page

Use the Database page to create and configure the report server databases that provide internal storage for one or more report server instances. If you are configuring a report server to use a remote report server database, you must use the Reporting Services Configuration tool to create the database.

Creating a report server database and configuring the connection is a multi-step process. To guide you through the steps, this page provides Wizards for each type of task. Permissions and logins are created or updated for you. You can monitor the status of each step in the Progress page. If an error occurs, you can click the error for information on how to resolve it.

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).

To open this page, start the Reporting Services Configuration tool and click Database in the navigation pane. For more information, see How to: Start Reporting Services Configuration.

Options

SQL Server Name

In Current Report Server Database, SQL Server Name specifies the name of the SQL Server 2005 or SQL Server 2008 Database Engine that runs the report server database. You can use a default or named instance on a local or remote computer.

Database Name

Specifies the name of the report server database that stores server data.

Report Server Mode

Indicates whether the report server database supports native mode or SharePoint integrated mode. For more information, see Planning a Deployment Mode.

Change Database

Start a wizard that guides you through all of the steps required for creating or selecting a report server database.

Credential Type

Specifies credentials that the report server uses to connect to the report server database. Credential types you can specify include the service account, a Windows domain user, Windows local user, or SQL Server database login. For more information about selecting credentials, see Configuring a Report Server Database Connection.

User 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>.

Password

Specifies the password for the account.

Change Credentials

Start a wizard that guides you through all of the steps required for selecting a different account or updating the password on the account that is used to connect to the report server database.

See Also

previous page start next page