the_open_door
coffee
ESEN
← Tools

sqsh

MS SQL client from Linux, an alternative when mssqlclient fails.

Interactive MS SQL Server client for Linux, built on FreeTDS. It plays the same role as impacket's `mssqlclient.py` and sometimes works where that one fails (older server versions, local instead of domain authentication). Its own quirk is that statements do not run until you type `go` on its own line, which surprises you the first time. From there you reach `xp_cmdshell` just the same to run commands as the service account.

Family Databases

Flags -S -U -P -h

Concepts Command execution in MSSQL (xp_cmdshell), IMPERSONATE in MSSQL (EXECUTE AS LOGIN)

Cheatsheet MS SQL Server · 1433

Installation

sudo apt install -y sqsh

Useful commands2 commands

Reference tool: it does not yet appear in a published machine on the blog, but it is part of the arsenal for its everyday use.