Use caseSQL Server database firewall

Stop risky SQL before it reaches SQL Server

SWOT DAM includes a database firewall, its SQL Gateway. It sits between your applications and SQL Server 2022 and decides every statement against policy before it runs, with nothing installed on the database. A blocked statement returns the database’s own policy error; the session stays open.

Book a demoSee it work

SQL Server limits to know before a pilot

  1. 01

    MARS

    The native engine refuses MARS. The Python engine supports it per listener, and a request over about 16 KB closes the session. Use the Python engine with MARS on, or turn MARS off.

  2. 02

    Extended Protection must be off

    Logins fail if Extended Protection is on. Turn it off for gateway connections.

  3. 03

    TDS 8 strict encryption

    TDS 8 strict encryption is not supported, so logins fail. Use Encrypt=Mandatory.

See it work

One query, two views

Pick a query from a sample session and see what is stopped before it reaches the database, and what SWOT DAM sees inside.

Sample session by db_support on Billing PostgreSQL.

SWOT PAM · at the door

Connected as

pam_tmp_db_support_8c1 temporary, removed on disconnect

Verdict

SWOT DAM · inside

Audit record

Sensitive columns

    Identity risk

    How it works

    How the SQL Server gateway works

    1. Point clients at the gateway

      Applications and tools connect to the SQL Gateway instead of the database. Verified on SQL Server 2022: ODBC 17 and 18, sqlcmd, Microsoft JDBC 12.8 with HikariCP, and bcp. .NET SqlClient, tedious and Go drivers are not tested: pilot first.

    2. Decide every statement

      Every statement is decided against policy before it runs. Rules match on user, source IP, sensitive tables, statement type and risk score.

      SWOT DAM
    3. Block the statement, keep the session

      A blocked statement returns the database’s own policy error and the session stays open, so applications keep working. Traffic the gateway cannot read is refused, never passed on.

    4. Monitor through SQL Server Audit

      SWOT DAM collectors read SQL Server Audit, the database’s own audit trail, and score each identity against its own 30-day baseline.

      SWOT DAM

    Questions

    Related

    Does SWOT DAM work as a SQL Server database firewall with ODBC and JDBC?

    Yes. ODBC 17 and 18 and Microsoft JDBC 12.8 with HikariCP are verified through the SQL Gateway on SQL Server 2022, as are sqlcmd and bcp. .NET SqlClient, tedious and Go drivers are not tested: pilot first.

    Are Windows-integrated logins supported?

    They are not verified against a Windows domain: the user is looked up after login. Register the SPN and pilot first. Every other limit is on the SWOT DAM gateway limits page.

    What does an application see when a statement is blocked?

    The database’s own policy error. The session stays open, so the application keeps working; only the risky statement is stopped.

    See it on your own systems

    A walk-through of SWOT DAM with the team that builds them.

    Book a demoContact us