Views:
Open a MariaDB read-only database for any third-party access or reporting tool. The read-only database is named ExternalAccess.

Procedure

  1. On the SMS, go to Admin → Database → External Database Settings → Edit.
  2. Select External Access Settings → Enable external database access.
  3. Enter the following:
    • Username – Provide the user name for an account with sufficient rights to read all the desired data from the SMS database.
    • Password – Enter and confirm the password.
  4. If you changed the external access settings, click Reboot to restart the SMS server and initialize the service.
    Note
    Note
    Follow your company’s server downtime policies, including notification to SMS clients of a pending reboot. Before you reboot the SMS, gracefully stop other client connections to the server.
  5. Click OK.
    If verification fails:
    • Verify that the username/password on the database matches the SMS.
    • Reboot the SMS before you try to access the database.
    • Running a complex report against SMS server may slow down the SMS response time significantly.