# 
        MS SQL Server
    
- Pen test and hack microsoft sql server (mssql)
- MSSQL Injection Cheat Sheet
- MSSQL Practical Injection Cheat Sheet
- PayloadsAllTheThings - MSSQL Injection
        # 
        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;
GOThen 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