# 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                                                                                          |
| <p>CloudAssert.CostManagement.</p><p>WindowsService.exe.config</p> | 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&#x20;
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.&#x20;
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* |
| <p><strong>ConfigureBilling</strong></p><p><strong>AndDacm</strong></p> | <p>For Multi Stamp Management components installation, </p><p>set this value as <strong>true</strong></p>               | *Required* |
| **BillingApiUser**                                                      | <p>Local Web user that will be created and used to access </p><p>the Cloud Assert Billing API service. Eg: apiadmin</p> | *Required* |
| <p><strong>BillingApi</strong></p><p><strong>Pass</strong></p>          | 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

![](https://3532473591-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M6voWNOkQYKxJnx1zI4%2F-M7u4CuEf1MH8k1GGSTf%2F-M7u9eFZUPgDEL3Pav5G%2Fimage.png?alt=media\&token=d0f0c3b2-95a9-4e4d-a6ca-78b95610500f)

* 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.&#x20;
  * 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.