Azure Stack Hub Billing
Cloud Assert HomeDocs Home
2010
2010
  • Introduction
  • Release Notes
  • Features
    • Admin Features
      • Settings
      • Pricing Profile
        • Manage Pricing Profiles
      • Usage History
      • Invoice
      • Quotas
      • Credits
        • User Credits
      • Usage & Quota
      • Notifications
      • Health Status
      • Billing Subscriptions
      • Billing Accounts
    • Tenant Features
      • Overview
      • Usage History
      • Invoice
      • Notifications
      • Usage and Quota
      • Billing Profile Creation
  • Installation
    • Prerequisites
      • PKI Certificate Requirements
      • Azure Stack Certification Authority certificate
    • Deployment
      • Install Billing Resource Provider
        • High Availability and Scale Deployment considerations
      • Operations and Monitoring
      • Billing Database and Log File Configuration
      • License Activation
      • Update VConnect Resource Provider With Billing Details
    • Configuration
      • Setup pricing profile and quotas
      • Invoice
      • Add Billing service to Azure Stack Plan
      • Add the resource provider in Tenant Portal
      • Mapping Subscriptions
      • How to add a new stamp as a connection?
    • Updates
      • Core Billing
      • Billing RP
        • Reset SQL Credentials
    • Remove Resource Provider
  • Others
    • Troubleshooting
      • Cost Management
    • Multi-Stamp Azure Stack Hub
Powered by GitBook
On this page

Was this helpful?

  1. Installation
  2. Updates
  3. Billing RP

Reset SQL Credentials

Article to Reset SQL credentials for Billing and DACM Database

PreviousBilling RPNextRemove Resource Provider

Last updated 2 years ago

Was this helpful?

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.

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'