Stack Overflow
Stack Overflow

Questions tagged [microsoft-machine-learning-server]

questions related to Microsoft Machine Learning Server - MS enterprise software for data science, providing R and Python interpreters.

Microsoft Machine Learning Server is enterprise software for data science, providing R and Python interpreters, base distributions of R and Python and additional high-performance libraries from Microsoft.

Useful links:

15 questions
2
votes
1 answer

Using a Azure Devops python artifact repo on a Microsoft machine learning server

I have a SQL Server 2017 instance with Machine Learning services install in database. I have a custom module that I have a wheels package built and published to a Azure Devops python artifact repo that I can install from other machines using the…
Brandon McClure
  • 1,329
  • 1
  • 11
  • 32
1
vote
1 answer

SQL Server ML. External Python Script: Access Denied Error

I am trying to make something useful with SQL Machine Learning Services and Python. I am trying to include an external python script into the SQL code. For now I am testing on SQL Server Management Studio on SQL Server 2019 Dev Edition. Folloing…
Wilmar
  • 558
  • 1
  • 5
  • 16
1
vote
0 answers

SQL Server 2017 MLS - Installing New Python Packages

I'm running SQL Server 2017 developer edition with Machine Learning Services (python V3.5.2). I got everything set up today and can successfully run sp_execute_external_script like the following: EXEC sp_execute_external_script @language…
Chris
  • 21
  • 2
1
vote
1 answer

Run multiple python version on SQL Server (2017)

Is it possible to run multiple Python versions on SQL Sever 2017? It is possible to do on Windows (2 Python folders, 2 shortcuts, 2 environment paths). But how to launch another Python version if I run Python via sp_execute_external_script in SQL…
Alex Ivanov
  • 657
  • 1
  • 8
  • 17
1
vote
1 answer

Machine Learning Server (SQL): how to backup and restore Python and Packages

After installation of numpy-1.18.1-cp35-cp35m-win_amd64.whl package in Python 3.5 ( SQL Server Machine Learning Services for windows x64, SQL Management Studio v17.9.1, MSSQL Server 2017) I recieved the error: Unable to communicate with the runtime…
Alex Ivanov
  • 657
  • 1
  • 8
  • 17
1
vote
1 answer

Unknown Error when install Microsoft Machine Learning Server 9.4.7 and Microsoft R Client 3.5.2

I want to install Microsoft Machine Learning Server 9.4.7 and Microsoft R Client 3.5.2, and I download the exe file from https://my.visualstudio.com/Downloads?q=Machine%20Learning%20Server%209.4.7%20for%20Windows&pgroup= and…
zhiwei li
  • 1,635
  • 8
  • 26
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…
Kessloshy
  • 1
  • 1
0
votes
1 answer

Remote Connection fails in setup of Python data-science client for SQL Server Machine Learning Services

I am trying to test the remote connection of a Python data-science client with SQL Server Machine Learning Services following this guide: https://learn.microsoft.com/en-us/sql/machine-learning/python/setup-python-client-tools-sql (section…
fnjo
  • 43
  • 5
0
votes
1 answer

[Python][SQL Machine Learning Services] Cannot install XGBoost on my SQL instance

I am trying to find a solution to my problem. We are trying to install XGBoost package on our MS SQL 2018 and we are facing this problem: Error Description The error (Błąd ogólny sieci. Zajrzyj do dokumentacji sieci.) is EN is 'General network…
yngwie_19
  • 1
0
votes
0 answers

How to connect R Server (Microsoft Machine Learning Server) to a SQL Server? Can connect locally but not remotely

I'm trying to load a very large dataset into R that is stored in SQL. I am able to use local R (Microsoft R Client 3.3.3.0) to connect to SQL via the following: library(RODBC) db <- odbcDriverConnect('driver={SQL…
coip
  • 1,312
  • 16
  • 30
0
votes
1 answer

SQL Server Machine Learning Services - Unable to launch the runtime. ErrorCode 0x80070032: 50(The request is not supported.)

Trying to configure MLS on SQL Server 2017, but when running a very basic external script like so: EXEC sp_execute_external_script @language =N'R', @script=N'OutputDataSet <- InputDataSet;', @input_data_1 =N'SELECT 1 AS hello' WITH RESULT SETS…
user3258158
  • 1
0
votes
0 answers

SQL Server Machine Learning call external REST API

I am testing some scenarios with SQL Server Machine learning. I was trying to query an external Web Service from inside a Python script in SQL Server Management Studio. Something like this: EXEC sp_execute_external_script @language =N'Python',…
Wilmar
  • 558
  • 1
  • 5
  • 16
0
votes
1 answer

SQL Server Python INTERNAL ERROR: should have tag

I am trying to integrate SQL Server 2017 or 2019 with Qunatlib using python. I can run Quantlib code which in this particular case is returning a Qunatlib schedule object which is an enumerated list of type Quantlib.Date. The code look like…
Ben Watson
  • 150
  • 2
  • 10
0
votes
2 answers

Query for R Machine Learning Services - Filtering Categories in Where Clause

I am trying to run a query in SQL Server using the Machine Learning Services extension. So this is the problem I am having; DECLARE @query NVARCHAR(MAX) = ' SELECT CATEGORY1,CATEGORY2 FROM TABLE WHERE CATEGORY1 = 'A' AND CATEGORY2 = 'B' ' EXEC…
Clifford Piehl
  • 483
  • 1
  • 4
  • 11
0
votes
1 answer

Machine Learning Server remote session setup fails

i want to setup the Machine Learning Server for R remote sessions. Unfortunately it fails with "Unknown Error". Here is what i did and what i got as output. Setup Installation of Microsoft Machine Learning Server 9.3.0 - Offline Installation / with…
abbgrade
  • 548
  • 5
  • 19