# 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 -SqlServerName "<fill-db-server-name>" -SqlUser "<fill-db-username>" -SqlPass "<fill-dbserver-password>" -VConnectDbName "<fill-vconnect-db-name>" -ConfigureBillingAndDacm $true 

> UpdateBuild.ps1 -SqlServerName "192.168.102.32" -SqlUser "sa" -SqlPass "MakeItWork!" -VConnectDbName "CloudAssert.VConnect" -ConfigureBillingAndDacm $true
```

| Parameter Name                                                          | Description                                                                                                                                                               | Required   |
| ----------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- |
| **SqlServerName**                                                       | IP Address. Specify instance if exists. Eg: 192.168.102.32                                                                                                                | *Required* |
| **SqlUser**                                                             | SQL Server authentication user name Eg: cadbadmin                                                                                                                         | *Required* |
| **SqlPass**                                                             | SQL server SQL authenticated user (cadbadmin) password                                                                                                                    | *Required* |
| **VConnectDbName**                                                      | Friendly name Eg: CloudAssert.VConnect                                                                                                                                    | *Required* |
| <p><strong>ConfigureBilling</strong></p><p><strong>AndDacm</strong></p> | <p>For installing Billing API and Cost management agent service in VConnect RP VM (Multi Stamp Management components), </p><p>set this value as <strong>true</strong></p> | *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.

![](https://670076824-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.