Configuring Microsoft SQL Server (MS SQL) connector in Dashboard

Prerequisites

  • The database must be reachable from the network where the product is deployed (for example, via a private DNS name or a routable IP address).
  • If a firewall is in place, ensure the database port is open.
  • Create a user account with read access to database metadata (schemas, tables, and views) for the product to run the scanning process.

Creating MS SQL Database Credentials

  1. Navigate to Administration > Data Sources and select MS SQL from the left-hand menu.
  2. Click Add Credentials to create new MS SQL connection credentials.

  3. Gather the required connection details:
    • Credentials name — any unique name, e.g., `PROD HR DB Credentials`
    • Hostname — e.g., `sql01.company.com`
    • Port — e.g., `1433` (default SQL server port)
    • Database name — e.g., `hrdb`
    • Username — e.g., `hrdb`
    • Password — e.g., `hrdb_password`

  4. (Optional) The connection uses the Microsoft SQL Server JDBC driver. If your environment requires additional JDBC properties, add them under Optional Settings. For example, to enforce SSL/TLS you can include:
    • encrypt=true
    • trustServerCertificate=false
  5. Click Save & Create Scan to save the credentials and proceed to the scan configuration. The system will attempt to connect and will display an error if the connection fails: