Assumption: Dashboard Service is running successfully for Access Commander already


The following steps are to be performed on the App Server


  1. Launch services.msc.
  2. Stop ACv4-AccessCommander service and ACv4-Dashboard service
  3. Navigate to AccessCommander\Configuration\Dashboard directory
  4. Edit run.bat using NotePad++
  5. Change MB_HOME directory from AccessCommander\Data\Dashboard\AccessCommander to AccessCommander\Data\Dashboard\Enterprise.
  6. Save the run.bat file.
  7. Start ACv4-Dashboard service



The following steps are to be performed from a local browser and not from within a server


  1. Navigate to the Dashboard URL set during Phase 2
  2. Login to the Dashboard Portal
    If you (the customer) requests for credentials, you will need to sign a Waiver of receiving no further support from MathCraft related to the Dashboard
  3. Go to Admin by clicking on Settings on the top right
  4. Navigate to General from the left navigation panel
  5. Ensure the Site URL is set to http://localhost:5020
  6. Ensure the Anonymous Tracking is set to Disabled
  7. Ensure the Friendly Table and Field Names is set to Disabled
  8. Ensure the Enable Nested Queries is set to Enabled
  9. Navigate to Updates from the left navigation panel
  10. Ensure the Check for Updates is set to Disabled
  11. Navigate to Public Sharing from the left navigation panel
  12. Ensure the Enable Public Sharing is set to Disabled
  13. Navigate to Embedding in Other Applications from the left navigation panel
  14. Click the Regenerate Key button
  15. Copy the Secret Key into a Notepad window as we will need this later
  16. Navigate to Caching from the left navigation panel
  17. Ensure the Enable Caching is set to Disabled
  18. Navigate to Databases from the top navigation panel
  19. Click on Access Commander under Name to modify the settings
  20. Ensure the Database Type is set to SQL Server
  21. Ensure the Name is set to Access Commander
  22. Enter the Host Name to match your SQL Server Name where Access Commander database is deployed
  23. Enter the Port Number to match your SQL Server Port Number where Access Commander database is deployed
  24. Ensure the Database is set to ACCMDRWEB
  25. Ensure the Database Instance is empty
  26. Ensure the Username is set to ac_mb_user
  27. Reenter the Password
  28. Ensure the "Use a Secure Connection (SSL)" is set to Disabled
  29. Ensure the "Use an SSH-Tunnel for Database Connections" is set to Disabled
  30. Ensure the "Automatically Run Queries when doing simple Filtering and Summarizing" is set to Enabled
  31. Ensure the "This is a large Database, so let me choose when Metabase Syncs and Scans" is set to Enabled
  32. Click on Save Changes
  33. Click on Sync Database Schema Now
  34. Wait for 10 minutes and then click Re-Scan Field Values Now
  35. Navigate to Databases from the top navigation panel
  36. Click on Portal Commander under Name to modify the settings
  37. Ensure the Database Type is set to SQL Server
  38. Ensure the Name is set to Portal Commander
  39. Enter the Host Name to match your SQL Server Name where Portal Commander database is deployed
  40. Enter the Port Number to match your SQL Server Port Number where Portal  Commander database is deployed
  41. Ensure the Database is set to PORTALCMDR
  42. Ensure the Database Instance is empty
  43. Ensure the Username is set to pc_mb_user
  44. Reenter the Password
  45. Ensure the "Use a Secure Connection (SSL)" is set to Disabled
  46. Ensure the "Use an SSH-Tunnel for Database Connections" is set to Disabled
  47. Ensure the "Automatically Run Queries when doing simple Filtering and Summarizing" is set to Enabled
  48. Ensure the "This is a large Database, so let me choose when Metabase Syncs and Scans" is set to Enabled
  49. Click on Save Changes
  50. Click on Sync Database Schema Now
  51. Wait for 10 minutes and then click Re-Scan Field Values Now
  52. On the App Environment Operating System, navigate to the AccessCommander\Configuration\AccessCommander directory from the Application Root
  53. Launch the application.properties in edit mode using Notepad or Notepad++ (Notepad++ recommended)
  54. Modify the metabase.secretKey copied in step 15 above
    metabase.secretKey=
  55. Save the application.properties file
  56. Launch the application.properties in edit mode using Notepad or Notepad++ (Notepad++ recommended)
  57. Modify the metabase.secretKey copied in step 15 above
    metabase.secretKey=
  58. Save the application.properties file