Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
A Reporting Services deployment uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer
and ReportServerTempdb
. ReportServerTempdb
is created with the primary report server database and is used to store temporary data, session information, and cached reports.
In Reporting Services, database administration tasks include backing up and restoring the report server databases. The tasks also include managing the encryption keys that are used to encrypt and decrypt sensitive data.
To administer the report server databases, SQL Server provides various tools.
You can use SQL Server Management Studio, the Transact-SQL commands, or the database command prompt utilities to:
For more information, see Move the report server databases to another computer (SSRS native mode).
To copy existing database content to another report server database, you can attach a copy of a report server database and use it with a different report server instance. Or, you can create and run a script that uses SOAP calls to recreate report server content in a new database. You can use the rs utility to run the script.
You can use the Database Setup page in the Reporting Services Configuration tool to manage connections between the report server and report server database. You can also use it to find out which database is used for a particular report server instance. To learn more about the report server connection to the report server database, see Configure a report server database connection (Report Server Configuration Manager).
The report server databases are used internally by the report server. Connections to either database are made by the Report Server service. You use the Reporting Services Configuration tool to configure the report server connection to the report server database.
Credentials for the report server connection to the database can be the service account, a Windows local or domain user account, or a SQL Server database user. You must choose an existing account for the connection. Reporting Services doesn't create accounts for you.
A SQL Server sign-in to the report server database is created for you automatically for the account you specify.
Permissions to the database are also configured automatically. The Reporting Services Configuration tool assigns the account or database user to the Public and RSExecRole roles for the report server databases. The RSExecRole provides permissions for accessing the database tables and for executing stored procedures. The RSExecRole is created in the primary database and msdb when you create the report server database. The RSExecRole is a member of the db_owner role for the report server databases, allowing the report server to update its own schema in support of an autoupgrade process.
When you create the primary database, the name of the database must follow the rules specified for Database identifiers. The temporary database name always uses the same name as the primary report server database but with a Tempdb suffix. You can't choose a different name for the temporary database.
Renaming a report server database isn't supported because the report server databases are considered internal components. Renaming the report server databases causes errors to occur. Specifically, if you rename the primary database, an error message explains that the database names are out of sync. If you rename the ReportServerTempdb database, the following internal error occurs later when you run reports:
"An internal error occurred on the report server. For more information, see the error log. (rsInternalError)
Invalid object name ReportServerTempDB.dbo.PersistedStream
."
This error occurs because the ReportServerTempdb
name is stored internally and used by stored procedures to perform internal operations. Renaming the temporary database prevents the stored procedures from working properly.
You can't enable snapshot isolation on the report server database. If snapshot isolation is turned on, you encounter the following error: "The selected report isn't ready for viewing. The report is still being rendered or a report snapshot isn't available."
If you didn't purposely enable snapshot isolation, the attribute might be set by another application or the model database might have snapshot isolation enabled, causing all new databases to inherit the setting.
To turn off snapshot isolation on the report server database, start Management Studio, open a new query window, paste and then run the following script:
ALTER DATABASE ReportServer
SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE ReportServerTempdb
SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE ReportServer
SET READ_COMMITTED_SNAPSHOT OFF
ALTER DATABASE ReportServerTempDb
SET READ_COMMITTED_SNAPSHOT OFF
In Reporting Services, explicit information about the database version isn't available. However, because database versions are always synchronized to product versions, you can use product version information to tell when the database version changed. Product version information for Reporting Services is indicated through file version information that appears in the log files, in the headers of all SOAP calls, and when you connect to the report server URL (for example, when you open a browser to https://localhost/reportserver
).
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Build reports for finance and operations apps - Training
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Report server database (native mode) - SQL Server Reporting Services (SSRS)
Learn how a native mode Reporting Services installation separates persistent data storage and temporary data storage into two databases.
What is Report Server Configuration Manager (Native mode)? - SQL Server Reporting Services (SSRS)
Learn about the Report Server Configuration Manager so that you can configure a SQL Server Reporting Services (SSRS) Native mode installation.
Configure the Report Server Service Account - SQL Server Reporting Services (SSRS)
Learn how to implement Reporting Services, a single service that contains a Report Server Web service, web portal, and a background processing application.