13.2 Planning Microsoft SQL Server Endpoint Deployment

Before you begin your Microsoft SQL Server endpoint deployment, read Deployment Requirements. The requirements and guidelines for Windows agent deployment are equally applicable to your SQL Server environment.

You can monitor Microsoft SQL Server endpoints with a locally installed Windows agent or using a proxy Windows agent. To audit a SQL Server endpoint or group of endpoints, you must install at least one Windows agent in the domain. The Windows proxy agent supports a maximum of 50 instances of Microsoft SQL Server from a single agent.

Secure Configuration Manager does not allow an endpoint to be monitored by more than one agent on a computer. You must use a unique endpoint name when you add a SQL Server endpoint, otherwise an error will occur. You can use Admin Reports to run a report containing every known agent on the computer and its associated system and endpoints. To run this report, select Tools > Admin Reports > All Systems, Agents, and Endpoints.