DataSunrise Security for MS SQL Server

MS SQL Server security tool by DataSunrise filters the network traffic according to configured rules set. Dangerous requests are blocked. Firewall protects enterprise sensitive data from multiple threats. It prevents hacker attacks, SQL-injections and other security breaches. Controls user privilegies to exclude the data loss by company insiders.

Tech Info

MS SQL Server security tool by DataSunrise provides high-level MS SQL Server security. It protects databases from both outside attacks and inside threats. It performs deep traffic filtering on application level. Every incoming and outgoing packet is analyzed for compliance with the customized rules set. In case of meeting a forbidden security rule the blocking scenario includes disconnection of a client from DB or closing of the session.

Proxy mode deployment prevents direct communication between client and database. The firewall acts as an intermediary between client and server, it audits and logs queries or blocks execution of the ones violating firewall's security policies.

proxy-01

Smart SQL analysis algorithms provide continuous monitoring of database activity. During initial traffic processing DataSunrise disassembles user queries, database output etc. Then the queries undergo careful analysis and the firewall determines target database objects, schemas, tables names and other important information. Then the firewall logs queries, blocks their execution or obfuscates database output according to predefined security policies.

 

Scanning of traffic along with detection and blocking mechanisms allows to capture SQL injections in real time. The firewall blocks the following SQL Injection techniques:

  • Union Exploitation Technique
  • Boolean Exploitation Technique
  • Out of band Exploitation technique
  • Time delay Exploitation technique
  • Automated Exploitation
  •  

    Rule conditions include the following parameters:

  • type, instance and name of the target database;
  • whether queries came from a certain client application;
  • whether intercepted queries contain certain SQL statements;
  • whether queries contain signs of SQL injection (OR and UNION statements, comments, double queries, constant expression, keyword in comments);
  • whether queries are directed to certain database elements (schemas, tables, columns, stored procedures).
  •  

    Among supported features there are:

  • TDS Proxy
  • SMP + TDS Proxy (MARS support)
  • SSL over TDS or SMP + TDS proxy
  • Sniffing for all protocol combinations (TDS, SMP+TDS, SSL+SMP+TDS)
  • SSL ciphers control
  • SQLBatch analysis, blocking and masking
  • RPCBatch analysis, blocking and masking
  • Asynchronous queries analysis (pipelining)
  •  

    DataSunrise Database Firewall supports the latest MS SQL Server Database versions: 2005, 2012, 2014, 2016, V12 (Azure). It runs on both Windows and Linux.