question

Kks-9125 avatar image
0 Votes"
Kks-9125 asked AnuragSharma-MSFT commented

Does R scripts are supported in Azure SQL database single instance?

As per the URL https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/r-developers-guide we can see that R scripts are supported with the below command running in managed instance
sp_configure 'external scripts enabled', 1;
RECONFIGURE WITH OVERRIDE;

I need R scripts to be run in Azure SQL Database. Could you please help us with the steps please

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT commented

Hi @Kks-9125, welcome to Microsoft Q&A forum.

Currently R language support is not present for Azure SQL Database(Paas). The document provided by you mentions the same.

To use R scripts, we can either go with Azure SQL Managed Instance or we can go with SQL Server on Azure Virtual Machines.

Please let me know if this helps.


If answer helps, please mark it 'Accept Answer'


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So for SQL server on VM also we need to run the same command?

0 Votes 0 ·

Hi @Kks-9125, thanks for the reply.

Yes thats the same command to enable external scripts on SQL Server configuration.

I would suggest you to go through the below article for step by step execution of R scripts.

Quickstart: Run simple R scripts with SQL machine learning


0 Votes 0 ·