Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.