> For the complete documentation index, see [llms.txt](https://docs.cloudassert.com/azure-stack-billing/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudassert.com/azure-stack-billing/2010/installation/updates/billing-rp/reset-sql-credentials.md).

# Reset SQL Credentials

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 <support@cloudassert.com> 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.

<figure><img src="/files/CBocnb4jwzZuTIdwF9aW" alt=""><figcaption></figcaption></figure>

5\. Enter the SQL Server Credentials.

<figure><img src="/files/qCuHKt3fkEhOyv4INC3Z" alt=""><figcaption></figcaption></figure>

6\. Enter the Billing Api Credentials.

<figure><img src="/files/dpKkkAvBG6FBTdyVFZHj" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/mBTwm8yMOIsOS8tssdp6" alt=""><figcaption></figcaption></figure>

7\. Restart Billing Agent Service.

<figure><img src="/files/w8ZzSRizIgAGhJe2DevV" alt=""><figcaption></figcaption></figure>

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