Database - Reporting Services Native mode (Configuration Manager)

  • Article

 

Applies To: SQL Server 2016

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 Manager to create the database.

Applies to: Reporting Services Native mode.

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 (SSRS Configuration Manager).

To open this page, start the Reporting Services Configuration Manager and click Database in the navigation pane. For more information, see Reporting Services Configuration Manager (Native Mode).

Options

SQL Server Name
In Current Report Server Database, SQL Server Name specifies the name of the SQL Server 2016 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.

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 (SSRS Configuration Manager).

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

Create a Native Mode Report Server Database (SSRS Configuration Manager)
Reporting Services Configuration Manager Help Topics
Report Server Database (SSRS Native Mode)
Configure a Report Server Database Connection (SSRS Configuration Manager)