Database configuration Template

Hi Community,

I am hoping someone can help with configuring a scan template for authenticated MSSQL database scanning in InsightVM.

SITUATION
We are scanning UAT Microsoft SQL Server 2019 instances using InsightVM Engine. The goal is to surface deep database configuration findings for audit closure.

WHAT IS WORKING

  • Windows host authentication is fully working (CIFS port 445 — Credential Success With Admin)
  • SQL Server authentication is confirmed working on port 1433 — scan logs show TDSDbService, TDSGroupDirectory, TDSUserDirectory, and TDSSystemFingerprinter all closing successfully with Configured Credentials
  • SQL Server CVEs are appearing based on version detection
  • Vulnerability count increases with each permission update confirming credentials are being used

WHAT IS NOT WORKING
Despite successful TDS authentication, deep SQL Server configuration findings are not appearing — specifically:

  • xp_cmdshell status
  • Authentication mode (Windows vs Mixed)
  • Transparent Data Encryption (TDE) status
  • Audit logging configuration
  • Excessive sysadmin role members
  • The Discovered Databases section is not appearing in the Audit Report

CURRENT TEMPLATE CONFIGURATION

  • Types of Checks: Asset Discovery :white_check_mark: | Vulnerabilities :white_check_mark: | Policies :white_check_mark:
  • Credentials: Windows Authentication using domain account
  • Permissions granted as per rapid7 documentation

QUESTIONS

  1. After enabling Policies in the scan template, do I need to specifically add CIS SQL Server benchmarks under a Policy Manager section for database configuration checks to appear?
  2. Should "Skip checks performed by Rapid7 Agent" be disabled given that the Insight Agent is also installed on the target servers?
  3. Is there a specific scan template setting that enables the "Discovered Databases" section to populate in the Audit Report?
  4. Are there any additional permissions beyond those documented in https://docs.rapid7.com/insightvm/database-credential-requirements-for-scanning-policies/ required for SQL Server configuration checks specifically?
  5. Lastly, could you share the exact configurations for the DB scanning template?

Any guidance from those who have successfully configured authenticated MSSQL database scanning would be greatly appreciated.

Thank you!