Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Configuring a Report Server Connection

SQL Server 2000

After installation, you may need to modify the user name, password, and authentication mode that the report server uses to connect to the report server database. These values are encrypted. Reporting Services includes rsconfig utility that you can use to modify encrypted connection information.

Connecting to a Report Server Database

A report server must access the report server database that stores the items and metadata managed by the server. Because the report server database is a SQL Server database, you can use either Windows Authentication or SQL Server Authentication.

The connection information used to establish the connection is initially defined during setup. However, if you want to modify the connection information, or if you are moving components to different computers, you can run rsconfig to correct it.

Running rsconfig

The rsconfig utility is a console application that you run from a command line. You can run this tool on a local or remote computer to modify the connection information used by a report server instance.

When you run the utility, you specify parameters to set connection information. These parameters change the values of the connection information stored in the configuration file on the local or remote computer. You can modify the user name, password, and authentication mode used by the report server to connect to the report server database. The tool manages connection information for a single instance of the report server.

For more information about syntax and errors, see rsconfig Utility and Error Reporting for rsconfig Utility.

See Also

Deploying and Administering Reporting Services

Configuring Reporting Services Components

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