# Reset SQL Credentials

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>
```

<figure><img src="https://1412215776-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LoOW0tKkl3hfpWMgkVr-4262638340%2Fuploads%2Fb57tteWYVTjW5BJhHRe7%2Fimage.png?alt=media&#x26;token=302b1956-1cc8-4f03-af59-7810bcb462ef" alt=""><figcaption></figcaption></figure>

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
```

<figure><img src="https://1412215776-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LoOW0tKkl3hfpWMgkVr-4262638340%2Fuploads%2FtiLIn7O88jgZIzLyPB2h%2Fimage.png?alt=media&#x26;token=a61e2345-cec4-42a6-9253-3978417f25dd" alt=""><figcaption></figcaption></figure>

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