SQL Server 執行 xp_cmdshell 錯誤排解

問題說明

在 SSMS 執行 xp_cmdshell 出現以下的錯誤訊息

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', search for 'xp_cmdshell' in SQL Server Books Online.

 

解決方式

參考 Enabling xp_cmdshell in SQL Server

執行 T-SQL

-- this turns on advanced options and is needed to configure xp_cmdshell

exec sp_configure 'show advanced options', '1'

RECONFIGURE

-- this enables xp_cmdshell

exec sp_configure 'xp_cmdshell', '1'

RECONFIGURE

 

或從 SSMS 介面調整設定