Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about what to do when MSSQL can not call Xp_CmdShell. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

When calling Xp_CmdShell with MSSQL, prompt "SQL Server blocks access to the component 'procedure of xp_cmdshell'' sys.xp_cmdshell' because this component has been turned off as part of the security configuration of this server, and the system administrator can enable 'xp_cmdshell'. by using sp_configure" For more information about enabling 'xp_cmdshell', see the Peripheral Application Configurator in SQL Server Books online. "the solution:

Execute (open)

; EXEC sp_configure show advanced options, 1: reconfigure exec sp_configure xp_cmdshell, 1: 1: reconfigure

Execute (close)

; EXEC sp_configure show advanced options, 1: reconfigure exec sp_configure xp_cmdshell, 0: reconfigure:

This is what the editor shares when MSSQL cannot call Xp_CmdShell. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.