Change Credentials Wizard (Configuration Manager)
Applies To: SQL Server 2016
The Reporting Services Configuration Manager 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 Configuration Manager 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 Manager. For instructions on how to start the Reporting Services Configuration Manager, see Reporting Services Configuration Manager (Native Mode).
Applies to: Reporting Services Native mode.
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 Manager 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 Manager.
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 Configure a Report Server Database Connection (SSRS Configuration Manager).
Summary
Verify the settings before the wizard runs.
Progress and Finish
Monitor the progress of each task.
See Also
Database - Reporting Services Native mode (Configuration Manager)
Change Database Wizard (Configuration Manager)
Create a Native Mode Report Server Database (SSRS Configuration Manager)
Reporting Services Configuration Manager Help Topics
Configure a Report Server Database Connection (SSRS Configuration Manager)