Create a Native Mode Report Server Database (SSRS Configuration Manager)
Applies To: SQL Server 2016 Preview
Native Mode Reporting Services uses a SQL Server database for internal storage. The database is required and it is used to store published reports, models, shared data sources, session data, resources, and server metadata.
To create a report server database or to change the connection string or credentials, use the options in the Database page in the Reporting Services Configuration Manager.
You must create and configure the report server database if you installed the report server in files-only mode.
If you installed Reporting Services in either the default configuration for native mode, the report server database was created and configured automatically when the report server instance was installed. You can use the Reporting Services Configuration Manager to view or modify the settings that Setup configured for you.
Creating or configuring a report server database is a multi-step process. Before you create the report server database, consider how you want to specify the following items:
- Select a database server
Review the supported versions of the SQL Server Database Engine and review the supported editions in the topic, Create a Report Server Database (SSRS Configuration Manager).
- Enable TCP/IP connections
Enable TCP/IP connections for the Database Engine. Some editions of the Database Engine do not enable TCP/IP by default. Instructions are provided in this topic.
- Open port for SQL Server
For a remote server, if you are using firewall software, you must open the port that the Database Engine listens on.
- Decide on report server credentials
Decide how the report server will connect to the report server databases. Credential types include domain user account, SQL Server database user account, or the Report Server service account.
These credentials are encrypted and stored in the RSReportServer.config file. The report server uses these credentials for ongoing connections to the report server database. If you want to use a Windows user account or a database user account, be sure to specify one that already exists. Although the Reporting Services Configuration Manager will create a login and set the necessary permissions, it will not create an account for you. For more information, see Configure a Report Server Database Connection (SSRS Configuration Manager).
- Decide on a report server language
Choose a language to specify for the report server. Predefined role names, descriptions, and the My Reports folders do not appear in different languages when users connect to the server using different language versions of a browser.
- Check credentials to create and provision the database
Verify that you have account credentials that have permission to create databases on the Database Engine instance. These credentials are used for a one-time connection to create the report server database and RSExecRole. If a login does not already exist, a database user login will be created for the account used by the report server to connect to the database. You can connect under the Microsoft Windows account you are logged in as, or you can enter a SQL Server database login.
To enable access to a remote report server database
If you are using a remote Database Engine instance, log on to the database server to verify or enable TCP/IP connections.
Point to Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and click SQL Server Configuration Manager.
Open SQL Server Network Configuration.
Select the instance.
Right-click TCP/IP and click Enabled.
Restart the service.
Open your firewall software and open the port that SQL Server listens on. For the default instance, this is typically port 1433 for TCP/IP connections. For more information, see Configure a Windows Firewall for Database Engine Access in SQL Server Books Online.
To create a local report server database
Start the Reporting Services Configuration Manager and connect to the report server instance for which you are creating the database. For more information, see Reporting Services Configuration Manager (Native Mode).
On the Database page, click Change Database.
Click Create a new report server database, and then click Next.
Connect to the instance of the Database Engine that you will use to create and host the report server database:
Type the SQL Server Database Engine instance that you want to use. The wizard will display a local Database Engine that runs as the default instance if it is available. Otherwise, you must type the server and instance to use. Named instances are specified in this format: <servername>\<instancename>.
Enter the credentials used for a one-time connection to the Database Engine for the purpose of creating the report server databases. For more information about how these credentials are used, see Before You Start in this topic.
Click Test Connection to validate the connection to the server.
Specify properties used to create the database. For more information about how these properties are used, see Before You Start in this topic:
Type the name of the report server database. A temporary database is created along with the primary database. Consider using a descriptive name to help you remember how the database is used. Note that the name you specify will be used for the lifetime of the database. You cannot rename a report server database after it is created.
Select the language in which you want role definitions and My Reports to appear.
The Report Server Mode is always set to Native.
Specify the credentials used by the report server to connect to the report server database.
Specify the authentication type:
Select Database Credentials to connect using a SQL Server database login that is already defined. Using database credentials is recommended if the report server is on a computer that is in a different domain, a non-trusted domain, or behind a firewall.
Select Windows Credentials if you have a least-privileged domain user account that has permission to log on to the computer and the database server.
Select Service Credentials if you want the report server to connect using its service account. With this option, the server connects using integrated security; credentials are not encrypted or stored.
Review the information on the Summary page to verify the settings are correct, and then click Next.
Verify the connection by clicking a URL on the Report Server URL page or Report Manager URL page. The URLs must be defined in order for this test to work. If the report server database connection is valid, you will see either the report server folder hierarchy or Report Manager in a browser window. For more information, see Verify a Reporting Services Installation in SQL Server Books Online.