Database

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 Create a Native Mode Report Server Database (Reporting Services).

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

Options

  • SQL Server Name
    In Current Report Server Database, SQL Server Name specifies the name of the SQL Server 2012 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 Reporting Services Report Server (SSRS).

  • 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 Configure a Report Server Database Connection (Native Mode).

  • 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

Tasks

Create a Native Mode Report Server Database (Reporting Services)

Concepts

Reporting Services Configuration F1 Help Topics

Report Server Database

Configure a Report Server Database Connection (Native Mode)

Other Resources

Configuring Reporting Services for Scale-Out Deployment