Export (0) Print
Expand All
8 out of 9 rated this helpful - Rate this topic

Activating a Report Server

SQL Server 2000

In Reporting Services, an activated server is one that can encrypt and decrypt data in a report server database. Activating a report server is required when a report server is installed, but is not in operation (that is, the server returns an "RSReportServerNotActivated" error in response to user and service requests).

A report server requires activation when you use rsconfig utility to add a report server to a Web farm. The rsconfig utility does not perform all of the deployment steps that a report server requires to be in operation. Activating a report server completes the deployment by creating a symmetric key used for reversible encryption. Because the Report Server Web service and the Report Sever Windows service run under two different user accounts, each service stores a copy of the symmetric key in the report server database.

The symmetric key is created by Report Sever Windows service when it first runs (either during setup or when you activate a report server manually). During activation, the Windows service pings the Web service, which in turn gets its copy of the symmetric key from the Windows service. This means that the first time the Web service runs, the Windows service must also be running.

How to Activate a Report Server

To activate a report server, you can use rsactivate, which is a console application that you run from a command line. When you run the utility, you specify parameters to select a report server instance to be activated.

Note  You can also use the Reporting Services WMI Provider to activate a report server. For more information, see Using the Reporting Services WMI Provider.

You must be a local administrator to run rsactivate. You can activate either a local or a remote report server. If you are activating a report server to join it to a Web farm, you must run rsactivate locally on a report server that is already part of a Web farm, and then specify the -m argument to select the remote report server that you want to activate. Internet Information Services (IIS) must be configured and running on the computer that has the report server you want to activate.

  1. Start the Report Server Windows service if it is not already running. For more information, see Starting and Stopping the Report Server Service.
  2. Open a command prompt: On the Start menu, click Run, type cmd in the text box, and then click OK.
  3. At the command prompt, type rsactivate and the parameter values you want to set. The following example illustrates how to use rsactivate to add a remote report server instance to a Web farm. The -m argument specifies the report server on a remote computer. The following command must be issued from the computer that is already part of the Web farm. The -u and -p passwords specify local administrator credentials to the remote computer.
    rsactivate -m<remotecomputername> -u<username> -p<password>
    
  4. Restart IIS.

A report server will be activated only if there is a match between the installation identifier and the public key. If the match succeeds, a symmetric key is created that permits reversible encryption. If the match fails, the report server is disabled, in which case you may be required to delete any encrypted data. For more information about encryption keys used by a report server, see Managing Encryption Keys.

In some cases, activating a report server is one step in a series of steps that result in restoring or recovering a report server installation. For more information, see Administering a Report Server Database.

How to Confirm a Report Server Activation

You can take the following actions to verify that the report server is activated.

  • Open Report Manager. Report Manager should open successfully. If you see an RSReportServerNotActivated error, the activation did not succeed.
  • In the report server database, open the Keys table and confirm that there are two entries for each report server. There should be one entry for the Report Server Windows service and one for the Web service.
See Also

Deploying and Administering Reporting Services Components

rsactivate Utility

Storing Encrypted Data in a Report Server Database

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.