To ensure the SQL Compliance Manager 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
|