# MS SQL Server

# Enable xp_cmdshell on MS SQL Server 2005+

# Manually

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1;
GO
-- To update the currently configured value for advanced options.
RECONFIGURE;
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1;
GO
-- To update the currently configured value for this feature.
RECONFIGURE;
GO

https://docs.microsoft.com/fr-fr/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-2017

Then execute code:

EXEC master..xp_cmdshell 'net user';

PS: It is enabled by default for MS SQL Server 2000

# mssqlclient

mssqlclient.py is part of Impacket and offers some bult-in helpers.

SQL> help

     lcd {path}                 - changes the current local directory to {path}
     exit                       - terminates the server process (and this session)
     enable_xp_cmdshell         - you know what it means
     disable_xp_cmdshell        - you know what it means
     xp_cmdshell {cmd}          - executes cmd using xp_cmdshell
     sp_start_job {cmd}         - executes cmd using the sql server agent (blind)
     ! {cmd}                    - executes a local shell cmd

mssql windows