Firewalls and TLS in SQL Server on Linux

In this video, we harden our SQL Server instance in two ways: by using a firewall to limit inbound traffic, and by using a certificate to force encrypted connections to SQL Server.

LINKS AND INFO
Catallaxy Services – https://www.catallaxyservices.com
Get the command line operations used in this video — https://36chambers.wordpress.com/2024/01/23/video-firewalls-and-tls-in-sql-server-on-linux/
Encrypt connections to SQL Server on Linux — https://learn.microsoft.com/sql/linux/sql-server-linux-encrypted-connections?view=sql-server-ver16&tabs=server
Uncomplicated Firewall (ufw) — https://ubuntu.com/server/docs/security-firewall
Allow Port 1433 Ubuntu Linux for SQL Server — https://stevestedman.com/2016/11/allow-port-1433-ubuntu-linux-sql-server/
netfilter — https://netfilter.org/
In-depth understanding of netfilter and iptables — https://www.sobyte.net/post/2022-04/understanding-netfilter-and-iptables/
[MS-TDS]: Tabular Data Stream Protocol — https://learn.microsoft.com/openspecs/windows_protocols/ms-tds/b46a581a-39de-4745-b076-ec4dbb7d13ec
TDS 8.0 — https://learn.microsoft.com/sql/relational-databases/security/networking/tds-8?view=sql-server-ver16

source

by Kevin Feasel

linux dns server