Version Update

Pre-Update Steps

SQL Server VM

Take a backup of Cloud Assert VConnect database

Resource Provider VM

Take a backup of following 8 files from their respective locations.

File Name	File Path
Web.config	C:\inetpub\MgmtSvc-CloudAssert-VConnect\Web.config
license.cal	C:\inetpub\MgmtSvc-CloudAssert-VConnect\bin\license.cal
Web.config	C:\inetpub\AzureStack-VConnectAdminExtension\Web.config
Web.config	C:\inetpub\AzureStack-VConnectRP\Web.config
Web.config	C:\inetpub\AzureStack-VConnectTenantExtension\Web.config
Web.config	C:\inetpub\MgmtSvc-CloudAssertBilling\Web.config
CloudAssert.CostManagement. WindowsService.exe.config	C:\Program Files\CloudAssertCostManagement\CloudAssert.CostManagement.WindowsService\CloudAssert.CostManagement.WindowsService.exe.config

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 -SqlServerName "<fill-db-server-name>" -SqlUser "<fill-db-username>" -SqlPass "<fill-dbserver-password>" -VConnectDbName "<fill-vconnect-db-name>" -ConfigureBillingAndDacm $true -BillingApiUser "<fill-billing-api-username-like-admin>" -BillingApiPass "<fill-billing-api-password>" -BillingDbName "<fill-billing-db-name>" -DacmDbName "<fill-dacm-db-name>"

> UpdateBuild.ps1 -SqlServerName "192.168.102.32" -SqlUser "sa" -SqlPass "MakeItWork!" -VConnectDbName "CloudAssert.VConnect" -ConfigureBillingAndDacm $true -BillingApiUser "admin" -BillingApiPass "MakeItWork!" -BillingDbName "CloudAssert.Billing" -DacmDbName "CloudAssert.Dacm"

Parameter Name	Description	Required
SqlServerName	IP Address. Specify instance if exists. Eg: 192.168.102.32	Required
SqlDbName	Friendly name Eg: CloudAssert.VConnect	Required
SqlUser	SQL Server authentication user name Eg: cadbadmin	Required
SqlPass	SQL server sa admin credential password	Required
VConnectDbName	Friendly name Eg: CloudAssert.VConnect	Required
ConfigureBilling AndDacm	For Multi Stamp Management components installation, set this value as true	Required
BillingApiUser	Local Web user that will be created and used to access the Cloud Assert Billing API service. Eg: apiadmin	Required
BillingApi Pass	Password for above BillingApiUser	Required
BillingDbName	Billing database name Eg: cloudassert.billing	Required
DacmDbName	Dacm database name Eg: cloudassert.dacm	Required

Verify deployment in Azure Stack Portals

• In the same Resource Provider VM, go to Control Panel -> Programs -> Programs and Features -> verify 3 services DACM (Cost Management agent service), Billing API and VConnect API exist and have the following versions:

  • VConnect Service - 2.2006.1.0

  • Billing API Service - 3.2006.1.0

  • DACM Agent Service - 1.2006.1.0

• 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

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.