日期:2014-05-18 浏览次数:20468 次
--开启xp_cmdshell --SQL Server blocked access to procedure 'xp_cmdshell' sp_configure 'show advanced options', 1 go reconfigure go sp_configure 'xp_cmdshell', 1 go reconfigure go --开启sp_OACreate --SQL Server blocked access to procedure 'sys.sp_OACreate' sp_configure 'show advanced options', 1; go reconfigure; go sp_configure 'ole automation procedures', 1; go reconfigure; go sp_configure 'Ad Hoc Distributed Queries',1; go reconfigure go
------解决方案--------------------
EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 GO
------解决方案--------------------
--开启xp_cmdshell --SQL Server blocked access to procedure 'xp_cmdshell' sp_configure 'show advanced options', 1 go reconfigure go sp_configure 'xp_cmdshell', 1 go reconfigure go --开启sp_OACreate --SQL Server blocked access to procedure 'sys.sp_OACreate' sp_configure 'show advanced options', 1; go reconfigure; go sp_configure 'ole automation procedures', 1; go reconfigure; go sp_configure 'Ad Hoc Distributed Queries',1; go reconfigure go