Overview
The GovWorx Data Agent connects to the Central Square OneSolution Reporting Database using a direct SQL connection. A dedicated read-only database user is required to ensure security and data integrity.
What You’ll Need
To prepare for the connection between the GovWorx Data Agent and your SQL Server, please gather the following configuration details:
Configuration | Explanation |
| The hostname or IP address of the SQL Server. For named instances, use the format |
| A SQL Server-authenticated user with read-only permissions on the required database objects. |
| The corresponding password for the SQL Server user account. |
| The name of the target database schema from which the Data Agent will read data (e.g., |
| Toggle will enable the use of a domain service account that is configured to run the agent service as authentication to SQL server |
Note: Fields marked with an asterisk (*) are required.
SQL Server Configuration Notes
To ensure a successful and secure connection, verify the following:
Firewall Access: Ensure the server hosting the GovWorx Data Agent can reach the SQL Server over the appropriate network and port (typically TCP 1433).
Minimum Permissions: The provided database user must have read-only access to relevant tables, views, or stored procedures. Write access is not required or recommended.
Instance Visibility: If using a named instance, confirm SQL Server Browser service is running, or explicitly provide the port number.
Troubleshooting Tips
Login Failed? Verify the SQL user is enabled and not locked out.
Timeout Errors? Check network routes and firewall rules.
Invalid Database? Ensure the
databasefield in the config matches the actual schema name.
Need Help?
For questions about setting up the SQL connection, or if you require assistance, please contact GovWorx Support at [email protected].