# 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   |
| ----------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- |
| <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* |
| **VConnectCertificateCN**                                               | VConnect SSL Certificate Common Name                                                                                                                                      | Optional   |

![Choose 1 and press enter to update VConnect MSM](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2F3nqGxbhQStyfPSrWgHc0%2Fimage.png?alt=media\&token=bba2625a-7c01-4770-9826-a02be1646ff0)

## 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.

{% hint style="info" %}
Cost Management agent service and Billing API will be available only if ConfigureBillingAndDacm parameter is set to $true while running UpdateBuild.ps1
{% endhint %}

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

## Check for Installed Version

```
> .\UpdateBuild.ps1 -ConfigureBillingAndDacm $false  
```

![Choose 2 and press enter to see the list of components installed with version](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2FcXTdXQmHbWrF2gb3YUSA%2Fimage.png?alt=media\&token=858eb1e3-6fba-489a-b577-1ae66c5c8c9c)

## 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](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2FI8Ham0lic5haxTeCeR1z%2Fimage.png?alt=media\&token=ff9d11d9-3784-4efe-89ee-ed00e5dc3cd7)

## Remove and Update SSL Certificate

![Choose 4 and press enter ](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2Ft2ljPm0TdIfsh6A8ZFPO%2Fimage.png?alt=media\&token=b594520b-fa45-4245-bcb0-d636877a5385)

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

![Paste the thumbprint of the certificate which you want to remove from cert store](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2FpybRtmPTf2aTcZnp3o6J%2Fimage.png?alt=media\&token=4b6d75bf-6678-47b3-b974-847bb8ef2768)

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](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2FC7LzjyeiWLFgE5ftlMm5%2Fimage.png?alt=media\&token=1c0d729f-73ed-4732-9171-7f00e764b274)

* 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](https://2310590130-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M6voWNOkQYKxJnx1zI4-1111339217%2Fuploads%2F0zh0zC9Wly43PN0lus6a%2Fimage.png?alt=media\&token=eabf3d23-e631-450e-affe-0f4fcfbf7458)

## 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.