Interest 15281, Level 16, State 1, Process sp_OACreate, Line 1
SQL Server blocked access to the procedure 'sys.sp_OACreate' of the component 'Ole Automation Procedures' because this component was shut down as part of the security configuration for this server. System administrators can enable 'Ole Automation Procedures' by using sp_configure. For more information about enabling Ole Automation Procedures, see Peripheral Application Configurator in the SQL Server Online Books series.
Msg 15281, Level 16, Status 1, Procedure sp_OAMethod, Line 1
SQL Server blocked access to the procedure 'sys.sp_OAMethod' of the component 'Ole Automation Procedures' because this component was shut down as part of the security configuration for this server. System administrators can enable 'Ole Automation Procedures' by using sp_configure. For more information about enabling Ole Automation Procedures, see Peripheral Application Configurator in the SQL Server Online Books series.
Solution:
- --开启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
|
Posted on 3/20/2015 3:25:12 PM
|
|
|
