Reset SQL Credentials

Article to reset SQL credentials for VConnect Database

The below steps are used to reset the SQL username or password

Steps to Reset SQL Credentials

1. Open a new PowerShell window in elevated mode and navigate to the directory where the VConnect Tool is present inside VConnect RP VM.

2. Run the following command to update the new Sql credentials.

.\VConnect.exe UpdateDatabaseSettings <DBServer Name or Ip>\<Instance Name>,<PortNumber> <VConnectDBName> <DBUsername> <DBPassword> /isUseIntegratedSecurity:false /VConnectApiEndpoint:https://localhost:44305 /VConnectApiUserName:<username> /VConnectApiPassword:<password>

3. Once the above command has succeeded, navigate to 'C:\Program Files\CloudAssertVConnect\CloudAssert.WAP.VConnect.AgentService'.

4. Run the following command to update the Sql credentials in VConnect Agent Service.

.\CloudAssert.WAP.VConnect.AgentService.exe UpdateDatabaseSettings <DBServer Name or Ip>\<Instance Name>,<PortNumber> <VConnectDBName> <DBUsername> <DBPassword> false

The above commands will update the new Sql credential in VConnect database and configuration files successfully.