To audit Microsoft SQL Server endpoints using the Windows agent, ensure that your environment meets all of the specified requirements for the Windows agent. For more information, see Windows Agent Computer Requirements.
In addition to the requirements for the Windows agent, ensure that your environment meets the following specific SQL Server requirements:
Microsoft Data Access Components (MDAC) 2.6 must be installed on the Windows agent computer.
If you choose to use the Named Pipes protocol to connect to a SQL Server instance, even if the SQL Server instance is using Mixed Mode authentication, the Windows agent must use an account that can be authenticated to the SQL Server’s domain controller.
You must specify an sa or equivalent super-user account for the SQL Server authenticated login account when you register the endpoint. Secure Configuration Manager and the Windows agent do not support the least privilege model (LPM).