5.6

Prerequisites
n
Use the command-line utility to back up the SSRS key to an encrypted file. See "Back Up Your SSRS
Key" on page 72.
n
Disable the Internet Explorer Protected Mode. See "Disable IE Protected Mode for SSRS" on page 72.
Procedure
1. On your Web server, start SQLServer 2008 R2 Reporting Services Configuration Manager.
a. Click Start, select Run, and type rsconfigtool.exe.
b. In the Reporting Services Configuration Connection dialog box, click Connect to connect and log in
to SQL Server 2008 R2 Reporting Services.
2. Update the SQL Server database.
a. In the navigation pane, click Database and click Change Database.
b. In the Report Server Database Configuration pane, verify that Action is selected.
c. On the Change Database page, select Create a new report server database and click Next.
d. Change the server name of your database server to the database machine and database instance
where SSRS will connect.
e. Verify that the authentication type is set to Current User – Integrated Security and click Test
Connection.
f. When the test message is successful, close the Test Connection dialog box and click Next.
g. On the Database pane, enter a name for the Database and select the language as English (United
States).
h. Set the Report Server Mode to Native Mode and click Next.
i. In the Credentials pane, change the Authentication Type to Windows Credentials, specify an
account, and click Next.
Specify an account that has permission to connect from the Web server to the database server, and
specify the password for the account.
j. In the Summary pane, review the selections and click Next.
k. In the Progress and Finish pane, resolve any errors, and click Finish.
3. Update the encryption keys.
a. In the navigation pane, click Encryption Keys.
b. In the Delete Encrypted Content area, click Delete and accept the prompt to delete all encrypted
data.
c. In the Change area, click Change to replace the encryption key, and click OK.
4. Configure the Web Service URL.
Three-Tier Split Installation
VMware, Inc.
73