Reset SQL Credentials

Article to Reset SQL credentials for Billing and DACM Database

The below steps are used to reset the SQL username or password in Billing and DACM config files

Steps to Reset SQL credentials

1. Please contact [e-mail] to get the Powershell script to reset SQL credential. Unblock the UpdateSqlCrdential.zip file and extract the contents to a temporary directory using any extractor tool inside the Billing RP VM.

2. Open a new elevated PowerShell window and navigate to the directory where the files have been extracted inside the Billing RP VM.

3. Run the following command.

 .\UpdateSqlCredential.ps1

4. Enter the SQL Server IP with port.

5. Enter the SQL Server Credentials.

6. Enter the Billing Api Credentials.

The script will update the new Sql Credential in Billing and DACM configuration files successfully.

7. Restart Billing Agent Service.

Note: Please find the backup of config files before update in 'C:\BackupConfig'