Troubleshooting: SQL Reporting Error "SQL Network Interfaces, Error: 26"

Version Affected: All
 
 

Overview

When clicking the Reports button for a realm that has SQL Database logging enabled, the Reports page can return a network error instead of loading the report.

Cause

The Reports button on any realm in the Admin Console uses the SQL database connection configured on SecureAuth0, not the connection configured on the realm being viewed. If SecureAuth0 itself does not have a working database connection configured, the error below appears no matter which realm's reports were being opened:

Resolution:

Configure the database connection on SecureAuth0:

1. In the Web Admin Console, select SecureAuth0.
2. Select the Logs tab.
3. Enable Database logging.
4. Configure the database connection.
5. Click Save.

SecureAuth Knowledge Base Articles provide information based on specific use cases and may not apply to all appliances or configurations. Be advised that these instructions could cause harm to the environment if not followed correctly or if they do not apply to the current use case.

Customers are responsible for their own due diligence prior to utilizing this information and agree that SecureAuth is not liable for any issues caused by misconfiguration directly or indirectly related to SecureAuth products.