Below are instructions to assist you with changing the VCM database to facilitate VCM in using https as well as the reporting.
- Open SQL Server Management Studio and connect to your database server.
- Click New Query, and select your VCM database.
- In the query field, type the following and execute:
select * from ecm_sysdat_configuration_values
where configuration_name like '%iis%'
- The fields that need to be updated are 'IIS Server', 'IIS HTTP' and iis_http_port_binding. To update them, replace the query field with the following and execute:
update ecm_sysdat_configuration_values
set configuration_value=hostname
where configuration_id is configuration_id
Note: Replace hostname with the VCM Server name in FQDN format, and configuration_id with the configuration_id next to IIS Server.
-
Repeat step 4 for the other fields by replacing configuration_id for IIS Server, IIS HTTP and/or iis_http_port_binding.
- In Windows, open IIS Manager and navigate to Server > Sites > Default Web Site.
Note: Replace Server with the name of your VCM server.
- Double click SSL Settings and check Require SSL.
- To allow users to connect without supplying their own certificate, click Ignore client certificates.
- To allow a user to supply their own certificate, use Accept client certificates.
- Click Default Web Site, then in the right pane, click Bindings.
- Click Add and configure a Type of https, IP address of All Unassigned, Port of 443, and the desired SSL certificate.
- In the Windows start menu, run rsconfigtool and connect to your VCM server.
- Click Report Manager URL, then click Advanced.
- Under Multiple SSL Identities for Report Manager, click Add.
- Set IP Address to (All IPv4), SSL Port to 443, and select the desired Certificate, then click OK.
- Click OK in the Advanced Multiple Web Site Configuration window.
- Open drive:\Program Files (x86)\VMware\VCM\WebConsole\Web.config in a text editor and update the reporting URLs from HTTP to HTTPS.
Example: <value>https://vcmcollector:443/ReportServer/ReportService2005.asmx</value>
- Save and close the file.
- Restart the IIS Service.
- Restart the Reporting Service in the RSConfigTool.
Verify by testing the new HTTPS URL and run a report to ensure it is also showing HTTPS.