SQL Reporting Services: How to configure the service account

To configure the Report Server service account

1. Start the Reporting Services Configuration manager and connect to the report server.

2. On the Service Account page, select the option that describes the type of account you want to use. For recommendations about which account type to specify, see Configuring the Report Server Service Account.

3. If you selected a Windows user account, specify the new account and password. The account cannot be more than 20 characters.

   If the report server is deployed in a network that supports Kerberos authentication, you must register the report server Service Principal Name (SPN) with the domain user account you just specified. For more information, see How to: Register a Service Principal Name (SPN) for a Report Server.

4. Click Apply.

5. When prompted to back up the symmetric key, type a file name and location for the symmetric key backup, type a password to lock and unlock the file, and then click OK.

6. If the report server uses the service account to connect to the report server database, the connection information will be updated to use the new account or password. Updating the connection information requires that you connect to the database. If the SQL Server Database Connection dialog box appears, enter credentials that have permission to connect to the database, and then click OK.

7. When prompted to restore the symmetric key, type the password you specified in step 5, and then click OK.

8. Review the status messages in the Results pane to verify all tasks completed successfully.

Jeff Loucks

Chief Strategy Officer | Winrox | 425-577-7377