To ensure the SQLcompliance Agent and Collection Server can successfully audit instances in your environment, open the following ports. For more information, see Supported installation scenarios.
| Environment Type | Port Requirements |
|---|
| Typical | - Port 5201 on the Collection Server computer
- Port 5200 on each computer hosting an audited SQL Server instance
|
| Clustered | - Port 5201 on the Collection Server computer
- Port 5200 on each cluster node hosting a virtual SQL Server you want to audit
|
| Non-trusted | - Port 5201 on the Collection Server computer
- Port 5200 on each computer hosting an audited SQL Server instance in a non-trusted domain or workgroup
|
SQL Compliance Manager audits all activity on your server. Learn more > >