SQL Server 阻止了对组件“Ole 自动化过程"的过程“sys.sp_OACreate"的访问 [英] SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'

问题描述

SQL Server 阻止访问组件的过程 sys.sp_OACreateOle 自动化程序"，因为此组件已关闭此服务器的安全配置的一部分.一个系统管理员可以通过以下方式启用Ole 自动化程序"使用 sp_configure.有关启用Ole"的更多信息自动化过程，请参阅 SQL Server 中的表面区域配置"在线图书.

SQL Server blocked access to procedure sys.sp_OACreate of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online.

我尝试将 Ole 自动化程序启用为:

I tried to enable Ole Automation Procedures as:

sp_configure 'show advanced options', 1 

GO 
RECONFIGURE; 
GO 
sp_configure 'Ole Automation Procedures', 1 
GO 
RECONFIGURE; 
GO 
sp_configure 'show advanced options', 1 
GO 
RECONFIGURE;

当我执行查询时，我成功获得了输出.但是当尝试通过 Windows 窗体时，我收到此错误.请帮帮我

When I am executing query, I'm successfully getting output. But when trying through windows forms, I'm getting this error. Please help me

推荐答案

以下示例显示了如何查看 OLE 自动化程序的当前设置.

The following example shows how to view the current setting of OLE Automation procedures.

EXEC sp_configure 'Ole Automation Procedures';
GO

以下示例显示了如何启用 OLE 自动化程序.

The following example shows how to enable OLE Automation procedures.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

这篇关于SQL Server 阻止了对组件“Ole 自动化过程"的过程“sys.sp_OACreate"的访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！