Enabling OLE Automation features in SQL Server 2014

Many architectures in the enterprise are moving towards service concept, as far as possible to use the Platform service mode for each application. As a result, the system will call the Web SERVICE,WCF or OData ... And many other types of services. In general, services are often used in AP to AP, however, sometimes the architecture must also use DB to call such services. Therefore, when SQL Server calls the Web service, you must do some set-up actions on SQL Server to call the Web Service service in the SQL Server's stored procedure, and this will be another day to write an article on how to call the Web in the stored procedure Service method. The following items are required for SQL Server to call the Web service

These objects belong to the system stored in the OLE Automation object, but based on security considerations, in SQL Server, the default objects are closed, to open these objects, first need to open the OLE Automation program, so that the SQL Using OLE objects in server 1. You can first query OLE Automation procedures The current state of exec sp_configure ' ole Automation procedures ';
Go however, you will encounter the following error when you execute it.

The main reason is that the preset advanced operation is closed, so it is not possible to query this setting state, so we must first turn on the Advanced option feature

sp_configure ' show advanced options ', 1;
GO
RECONFIGURE, the above is enabled, if you want to turn off 1 to 0, then query OLE Automation procedures can get the following results, there is no error

Service message

You can learn that Ole Automation Procesures is not yet open. You must turn on this feature later

2. Enable OLE Automation Procesures, change the following address from 1 to 0, which is disable

sp_configure ' Ole Automation procedures ', 1;
GO
RECONFIGURE;

This allows the OLE Automation to be opened so that the service can be called in the event of a subsequent application.

Enabling OLE Automation features in SQL Server 2014