-
Titel
Failed to connect to SMA Database - Troubleshooting Checklist -
Beschreibung
When attempting to connect to the KACE SMA Database for reporting with a third party tool such as Toad, mySQL Workbench or PowerBI and continually failing to connect due to connections refused or no access. -
Ursache
This could be caused by no access to Port 3306 for KACE SMA, which is required for Remote Read-Only Database Access (ODBC) -
Lösung
The KACE SMA requires a few settings to enable access to the database through a third party tool, which will also require access through port 3306. Please follow this quick troubleshooting checklist for failed connection to MySQL.
Troubleshooting Checklist
- Confirm database access is enabled
- Confirm correct credentials for Reporting User Password
- Ensure proper access to KACE SMA
Confirm database access is enabled
Go to Settings | Control Panel | Security Settings and check for "Enable database access" and save and restart services. This will enable port 3306 for the appliance.
Confirm correct credentials for Reporting User Password
Go to Settings | Control Panel | General Settings and scroll to Update Reporting User Password. Please update to a known password and use credentials provided to access database.
Ensure proper access to KACE SMA
Test through telnet, nMap, Wireshark or PortQry for Appliance ports listening. Please test following ports: 3306, 443 and 80. Prior to following these instructions, it will be necessary to use a network scanning tool (PortQry or a similar tool).
If tested with PortQry the results should be the following:
TCP port 3306 (unknown service): LISTENING TCP port 443 (https service): LISTENING TCP port 80 (http service): LISTENING
If port 3306 is not LISTENING, please review firewall and network permission for port 3306 inbound for KACE Appliance.
After confirming port 3306 is open in network and the Appliance is NOT LISTENING on required ports. Gather screenshots for Failed Connection, KACE SMA Settings and port test results and please contact Quest KACE Technical Support to resolve this issue.