Change Credentials Wizard (Reporting Services Configuration)

SQL Server Setup

The Reporting Services Configuration tool provides the Change Credentials Wizard to guide you through the steps of reconfiguring the account that the report server uses to connect to the report server database. When you change credentials, the tool will update all permissions and database login information on the database server for the report server database that is actively used by the report server.

To start the wizard, click Change Credentials on the Database page in the Reporting Services Configuration tool. For instructions on how to start the Reporting Services Configuration tool, see How to: Start Reporting Services Configuration.

Options

Database Server

Specifies the name of the SQL Server Database Engine instance that runs the report server database.

To connect to the Database Engine instance, you must use credentials that have permission to log on to the server and update database information. The Reporting Services Configuration tool uses your current Windows credentials, but if you do not have a login or database permissions, you can specify a SQL Server database login.

You cannot specify different Windows credentials. If you want to connect as a different Windows user, login as that user and then start the Reporting Services Configuration tool.

Credentials

Specifies the account by which the report server connects to the report server database. Valid values include the service account of the Report Server Web service, a SQL Server database login defined on the Database Engine instance you are using to host the report server, or a Windows account. If you are using a Windows account, you can specify a local account (<computername>\<username>) if the report server and the database are on the same computer, or a domain user account (<domain>\<username>) if they are on different computers in the same domain.

The report server will create a database login and assign database permissions for the account you specify.

The report server does not create the account itself. The account you specify must already exist and it must be valid for your deployment configuration. Specifically, if the database is on a remote computer and you want to use a Windows account, you must specify an account that has log on permissions on that computer.

If the computer is in a different or non-trusted domain, consider using a SQL Server database login. For more information about choosing an account, see Configuring a Report Server Database Connection.

Summary

Verify the settings before the wizard runs.

Progress and Finish

Monitor the progress of each task.

See Also