Overview
The Data Agent will read from the LOGIS Reporting/Replicated SQL Database. To do this we need a user to connect.
To prepare for this connection, we need the following details.
Configuration | Explanation |
| Host of the reporting database |
TOGGLE: | Whether to use gMSA to authenticate to the database. Either enable this or supply both a username and password. |
| Database user |
| Database password |
| Database Schema to read from |
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.Note: Fields marked with an asterisk (*) are required.
Network Requirements: The server running the Data Agent should be able to connect to the CAD Reporting server over port 1433. This can be tested using PowerShell.
PowerShell Command:
Test-NetConnection -ComputerName {CAD Reporting Server name or IP} -Port 1433