5.7

a. In Reporting Services Configuration Manager, click Encryption Keys and click Delete to delete
encrypted content.
b. In the navigation pane, click Service Account and enter the app_pool_account account for the
database connection.
9. Open a command prompt to set the service principal names directory property for the Active
Directory service accounts.
a. Click Start, select All Programs > Accessories, right-click Command Prompt, and select Run as
administrator.
b. Type: Setspn -a MSSQLSvc/db_server_name domain\sql_server_account_name and press Enter.
c. Type: Setspn -a MSSQLSvc/db_server_name:1433 domain\sql_server_account_name and press
Enter.
d. Type: Setspn -a MSSQLSvc/db_server_fqdn domain\sql_server_account_name and press Enter.
e. Type: Setspn -a MSSQLSvc/db_server_fqdn:1433 domain\sql_server_account_name and press
Enter.
10. Verify whether SSRSis running on the SQLServer and if it is not running, locate and update the
Report Server configuration file named rsreportserver.config.
a. Locate the AuthenticationTypes XML element.
b. Remove <RSWindowsNTLM/> and <RSWindowsBasic/>.
c. Add <RSWindowsNegotiate/> and <RSWindowsKerberos/>.
The default location for the configuration file is C:\Program Files\Microsoft SQL
ServerReportingServicesInstance\Reporting
Services\ReportServer\rsreportserver.config.
11. In SQL Server Management Studio, grant the Application Pool user access to the VCM and VCM_Unix
databases, with membership in the VCM__SelectRole_General role in each database.
12. (Optional) If you did not configure the SQL Server Reporting Services service to run as the
IISApplication Pool account before installing VCM, start Internet Explorer as administrator and set the
report settings.
a. Click Start, select All Programs, right-click Internet Explorer and select Run as administrator.
b. Connect to http://localhost/Reports/Pages/Folder.aspx.
c. Click ECM Reports and click the ECM data source to display the properties menu.
d. To use integrated authentication, type the following text into the Connection string text box and
click Apply.
Integrated Security=SSPI;Data Source=db_server_name;Initial
Catalog=VCM;LANGUAGE=us_english;
e. Click the back button to return to the ECM Reports view.
13. Select Folder Settings, select Security, select the new SSRS user or group, and click New Role
Assignment.
14. Click Browser to allow the VCM SSRS user or group to view folders and reports and subscribe to
reports, and click OK.
Three-Tier Split Installation
VMware, Inc.
109