Overview
The Data Agent connects to a Microsoft SQL Server database using either integrated security or a username and password.
Configuration | Explanation |
Host | Host on which to find the database |
Use Integrated Security | Whether to use Windows Authentication for the SQL Server connection |
Username | Database username. Provide when not using integrated security. |
Password | Database password. Provide when not using integrated security. |
Database Name | Database name |
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