Thursday, November 23, 2017

External Scripts Enabled server configuration option

This configuration setting is applied for SQL Server 2016 R Services (In-Database) and SQL Server 2017 Machine Learning Services (In-Database).
Use the external scripts enabled option to enable the execution of scripts  with certain remote language extensions (in this case R or Python language). This property is OFF by default. When Advanced Analytics Services is installed, setup can optionally set this property to true. To enable normal function of this external stored procedure, we must have administrator access to your SQL Server instance in order to run sp_configure command (and set following configuration):
EXECUTE sp_configure;
GO
----To enable execution of external script add an argument:
EXECUTE sp_configure 'external scripts enabled', 1;
GO
-----And after that run the reconfiguration as:
RECONFIGURE;
GO
----- After configuration the value sould be like as
name
minimum
maximum
config_value
run_value
external scripts enabled
0
1
1
1
Note: We must have to restart SQL Server to make this change effective. It would be great if we could restart SQL Server Launchpad (SQLSERVER) services also.
SP_EXECUTE_EXTERNAL_SCRIPT is a system stored procedure in SQL Server 2016 onward which is responsible to execute the provided script as argument on external script to a provided language.
Conclusion

To External Scripts Enabled server configuration option, we must have the administrator privileges on the SQL Server and after configuration it, we should restart the SQL Server services and have to check if SQL Server Launchpad services is still running or not. 

3 comments:

  1. whats up, this weekend is delightful for me, by means of now this era i'm analyzing this big informative article right here at my habitat. About Jay Shetty

    ReplyDelete
  2. Manufacture a business around something you are energetic about and profiting on the web will turn out to be progressively reasonable and worthwhile for you.make money online

    ReplyDelete

Popular Posts

Get Sponsored by Big Brands