Questions tagged [sql-server-ml-services]

7 questions
3
votes
2 answers

Accept EULA error when running Python script in SQL Server

I'm getting the error shown below when running Python script from SQL Server. I already installed ML services and reconfigured parameter external scripts enabled to 1. This is a SQL Server Developer edition installed on Windows 10. Msg 39111,…
Elvin Ahmadov
  • 536
  • 5
  • 10
3
votes
1 answer

How to install and update Python Libraries into SQL ML Server instance?

I have a problem with upgrading and installing python packages on SQL Server Machine Learning Services in in-database instance. I have tried both in-database installation using pip (from the proper instance) and remote client installation using…
Marko_Apost
  • 33
  • 1
  • 4
1
vote
1 answer

MemoryError: Microsoft ML Services with Python

The following script works well is small samples EXECUTE sp_execute_external_script @language = N'Python', @script = N' print(df_training["flResp"].value_counts())', @input_data_1 = N'SELECT * FROM tb_training_teste', @input_data_1_name =…
ruikomi
  • 11
  • 1
0
votes
0 answers

Update InputDataSet table in SQL Server while executing R-Services

In a SQL Server database I have an InputTable whose data is given to a stored procedure which runs an R-script on the rows whose Flag=0 after running the script I want to set Flag=1 on the specific rows of InputTable on which the script was…
heisenbug29
  • 123
  • 1
  • 10
0
votes
0 answers

SQL Server 2019 - Machine Learning Services - Failed to install Machine Learning Services on a Windows Failover Cluster instance

I followed these steps to add ML services (R & Python) to an existing failover cluster instance of SQL Server 2019 (The installation media was ran on one of the cluster nodes): install - Installation Type install - Feature Selection i try to skip…
0
votes
1 answer

sql server ML service gives low memory error for large data (Association Rule Mining Project)

I have a project that I want to find the rules of correlation between goods in the shopping cart .to do this ,I use the ML service(Python) in Sql Server ,and I use the mlxtend library to find the association rule.but the problem I have is that the…
0
votes
1 answer

Reading the results of my Python GET request in SQL Server Machine Learning Services

I am putting together a simple Python script, utilising the Python Machine Learning Services features in SQL Server. The goal is that my SQL server can ping an external API using a python script and read the results into variables. I have…