Version Update

Pre-Update Steps

SQL Server VM

Take a backup of Cloud Assert VConnect database, Billing and Cost management database (for Multi Stamp Management).

Update Steps

Resource Provider VM

1. Sign in to VConnect Resource Provider Virtual Machine

2. Unblock the VConnect Resource Provider update package .zip file and extract the contents to a temporary directory using any extractor tool

3. Open a new elevated (administrative) PowerShell console and change to the directory where the files have been extracted. Use a new window to avoid problems that might arise from incorrect PowerShell modules that are already loaded on the system.

4. Run UpdateBuild.ps1 with required parameters

> .\UpdateBuild.ps1 -ConfigureBillingAndDacm $true  

Parameter Name	Description	Required
ConfigureBilling AndDacm	For installing Billing API and Cost management agent service in VConnect RP VM (Multi Stamp Management components), set this value as true	Required
VConnectCertificateCN	VConnect SSL Certificate Common Name	Optional

Choose 1 and press enter to update VConnect MSM

Verify deployment in Azure Stack Portals

• In the same Resource Provider VM, go to Control Panel -> Programs -> Programs and Features -> verify if VConnect API, Cost Management agent service and Billing API exist.

Cost Management agent service and Billing API will be available only if ConfigureBillingAndDacm parameter is set to $true while running UpdateBuild.ps1

• In Admin portal, go to All Services -> VConnect -> Azure Stack Hub, verify if it loads properly

• In Tenant portal, go to All Services -> All Regions, verify if it loads properly

Check for Installed Version

> .\UpdateBuild.ps1 -ConfigureBillingAndDacm $false  

Choose 2 and press enter to see the list of components installed with version

IIS SSL Certificate with Expiry

.\UpdateBuild.ps1 -ConfigureBillingAndDacm $false 

Choose 3 and press enter to see the list of SSL certificate used in IIS for SSL binding with Expiry Date

Remove and Update SSL Certificate

Choose 4 and press enter

When asked for thumbprint, paste the thumbprint of the certificate which you want to remove from cert store

Paste the thumbprint of the certificate which you want to remove from cert store

When asked for certificate path, give the full path of the PFX certificate with filename and extension.

Provide the PFX file path with filename and extension

• Then provide the certificate password

• Confirm if the list of site which is using the old certificate for SSL binding is correct

• List of site bindings which are updated with the new thumbprint will be shown with port information

List of sites updated with the new thumbprint

FAQ

• Where can I find VConnect database details?

  • In Admin Portal, go to All Services -> VConnect → Settings → Database settings to find the details

• Where can I find VConnect database details?

  • Open a PowerShell window

  • Navigate to the location of VConnect tool (~\Setup\VConnectTool). This is inside the update package unzipped folder where this update got installed.

  • Run the below command by replacing the path of web.config with appropriate location

> VCONNECT.EXE UnsecureConfig C:\inetpub\MgmtSvc-CloudAssertBilling\Web.config

Please find database details in Connection String section and Billing API username and password from AppSettings section.