How to Run the Admin Utility in Bold Reports for Azure App Service

Please refer this KB for instructions on how to reset the database of the Bold Reports on Azure app service

Step 1: Upload utilities folder in advance tools

1. Go to advance tools
   

   

2. Choose Powershell option
   

   

3. Upload unzip the below mentioned utilities folder and drag and drop the utilities folder in the location of C:\home\site\wwwroot
   

   

Utilities folder : Utility Folder

Step 2: Run the adminutils

1. Navigate to below location:

   cd C:\home\site\wwwroot\utilities\adminutils 
   

   

2. fter changing the directory, run the following command to reset the database:

   Syncfusion.Server.Commands.Utility.exe dbconfig -servername "localhost" -databasename "BoldBIMasterDatabase" -u "Admin" -p "Admin@12345" -iswindowsauthentication false -sslenabled false -port "5432" -additionalparameters "Pooling=True" 
   

   IMPORTANT: command details:
   servername – SQL server hostname/IP
   databasename – SQL database name
   u – SQL server username
   p – SQL server password
   port - Port number required for PostgreSQL and MySQL
   iswindowsauthentication – Is windows authentication required (Required for MSSQL only)
   sslenabled – Is encrypted connection required (this is optional)
   additionalparameters - Additional parameters required for database connection (this is optional)

3. Once the database has been updated successfully, restart the application