'Can R access internet whilst running as an external script in SQL Server?

I run the R portion of the code in Rstudio, and it works fine. But when I call it inside SQL Server, it runs successfully, but cant return any results, only "I've got nothin'" which is the default error of the wikifacts package when it cant find a result to return.

EXEC sp_execute_external_script       
                    @language = N'R',
                    @script = N' 

                    library(wikifacts)
                    query <- "Microsoft"
                    answer <- as.data.frame(wiki_define(query, sentence = 1))
                    print(answer)
                    '

Im just wondering if its being blocked along the way, or not possible to call external data from SQL server? And what a possible workaround could be?

sqlr


Solution 1:[1]

Solved..!

For anyone who wants to know, I had to disable outbound firewall rules for SQL server.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Maz

Related Questions