Tue, Dec 13 2011 15:57
SQL Reporting Services: How to configure the service account
To configure the Report Server service account
Start the Reporting Services Configuration manager and connect to the report server.
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.
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.
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.
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.
When prompted to restore the symmetric key, type the password you specified in step 5, and then click OK.
Review the status messages in the Results pane to verify all tasks completed successfully.
Chief Strategy Officer | Winrox | 425-577-7377
Filed under: SQL Server, How To, Reporting Services, Service Account