Database Reference
In-Depth Information
To join a scale-out deployment, a report server must create and store its copy of the
symmetric key in the shared database within remote report server. The initialization process
for a scale-out deployment differs in how the report server gets the symmetric key.
F
When the first server is initialized, it gets the symmetric key from Windows
F
When the second server is initialized during configuration for scale-out deployment, it
gets the symmetric key from the Report Server service that is already initialized
F
The first report server instance uses the public key of the second instance to create
an encrypted copy of the symmetric key for the second report server instance; and
the symmetric key is never exposed as plain text at any point in this process
We can control scale-out deployment membership by adding and removing encryption
keys for specific report server instances using the
rskeymgmt.exe
utility. We need to
do this manually from one of the other computers in the scale-out deployment by following
these steps:
F
To list the announced report servers currently in the database:
RSKeyMgmt—l
F
This will provide you with a list in the format:
MachineName\Instance—<GUID
of
the
instance>
(Note the GUID of the instance you wish to remove)
F
To remove the instance of SQL Reporting Services:
RSKeyMgmt
-r
<GUID
of
the
instance
noted
previously>
We will be asked to confirm whether or not we wish to delete the key we have entered. The
nodes from the deployment can be removed in any order. If, in case of adding nodes to the
deployment, then we must join any new instances from a report server that is already part
of the deployment.
There's more…
After all the relevant changes are performed for a scale-out deployment method, when we
start up the Reporting Services Configuration tool it might change the
<ReportServerUrl>
settings to the default value.
It is a best practice to keep a backup copy of the configuration
files in case there is a need to replace them with the version
that contains the settings that you want to use.
See Also
Preparing and Installing Reporting Services, which highlights the new deployment mode that
is available in SQL Server 2008 R2.
Search WWH ::
Custom Search