Database Reference
In-Depth Information
F
Reporting Services database size should be as follows:
RSTempDB
or
ReportServerTempdb
: The size of this database varies,
depending on the number of concurrent users to access report servers
RSDB
or
ReportServer
: A general rule of thumb is that the report definition
will take around 250KB of disk space, which is larger than the actual size
of RDL
F
The database size is determined by the multiplication result of the size of report and
the number of concurrent users; and each live report that is executed will generate
a report snapshot that is persisted in
ReportServerTempDB
database for the
duration of the user's session
While going through the requirements of Reporting Services scale-out deployment the users
must take the following things into consideration:
F
Using the Developer edition or Enterprise Evaluation edition, you can deploy scale-out
configuration, but the only limitation is that the Developer edition cannot be used for
production purposes and the Enterprise Evaluation will expire after 180 days
F
The report servers must be in the same domain or have a trusted-domain
relationship enabled in case multiple domains are involved
F
Reporting Services do not synchronize custom permission settings between the
different authentication types
The required tools to implement reporting services to scale-out deployment are the SQL
Server setup media and the Reporting Services Configuration tool (
rskeymgmt
utility), which
is located at
<drive>:\Program Files\Microsoft SQL Server\100\Tools\Bin
.
How to do it...
The following steps enable you to deploy a scale-out methodology for SQL Server Reporting
Services (SSRS). The process is a two-fold method that starts with a deployment model. It
is done by configuring multiple report servers to use a shared report server database and
manage encryption keys to perform encrypt and decrypt data in a report server database. The
initial steps are to configure the report servers explained as follows:
1.
Use the SQL Server Setup to install each report server instance, choose a server
which is classified as the master server.
Search WWH ::
Custom Search