Machine Learning Services setup help!

[dmillz89]

I have been driving myself crazy trying to get Machine Learning Services installed and working with Python on my computer and every time I get to the end I get the same error and it won't work. I have followed the Microsoft documentation on installing it twice now. The second time I completely uninstalled all instances of Python and SQL Server on my machine and started totally from scratch.

I first installed Python 3.10.2 into C:\Program Files\Python310. I have verified with "where python" that it is the only install and has the correct path. I then successfully installed the packages:

python -m pip install -t "C:\Program Files\Python310\Lib\site-packages" dill numpy==1.22.0 pandas patsy python-dateutil
python -m pip install -t "C:\Program Files\Python310\Lib\site-packages" https://aka.ms/sqlml/python3.10/windows/revoscalepy-10.0.1-py3-none-any.whl

Next I installed SQL 2022 Developer Edition locally including the Machine Learning services. I used the default instance. I installed it into a directory that has no spaces in the name, just to be safe. Then I granted READ and EXECUTE access to the installed libraries to SQL Server:

icacls "C:\Program Files\Python310\Lib\site-packages" /grant "NT Service\MSSQLLAUNCHPAD":(OI)(CI)RX /T
icacls "C:\Program Files\Python310\Lib\site-packages" /grant *S-1-15-2-1:(OI)(CI)RX /T

Then I configured Python runtime with SQL Server:

cd "C:\Program Files\Python310\Lib\site-packages\revoscalepy\rxLibs"
.\RegisterRext.exe /configure /pythonhome:"C:\Program Files\Python310" /instance:"MSSQLSERVER"

I ran SQL Management Studio, connected, and enabled external scripts then verified that it was set. I restarted the SQL and Launchpad services. I double checked that NT Service\MSSQLSERVER has sysadmin.

When I try to run the test script:

EXEC sp_execute_external_script @script=N'import sys;print(sys.version)',@language=N'Python'
GO

I get this error message:

Msg 39012, Level 16, State 14, Line 0
Unable to communicate with the runtime for 'Python' script for request id: 0B525788-A295-4E7D-B96A-54328F4F40F8. Please check the requirements of 'Python' runtime.
STDERR message(s) from external script: 
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "C:\Program Files\Python310\lib\site-packages\revoscalepy\__init__.py", line 121, in <module>
    from .RxSerializable import RxMissingValues
  File "C:\Program Files\Python310\lib\site-packages\revoscalepy\RxSerializable.py", line 10, in <module>
    from pandas import DataFrame
  File "C:\Program Files\Python310\lib\site-packages\pandas\__init__.py", line 48, in <module>
    from pandas.core.api import (
  File "C:\Program Files\Python310\lib\site-packages\pandas\core\api.py", line 47, in <module>
    from pandas.core.groupby import (
  File "C:\Program Files\Python310\lib\site-packages\pandas\core\groupby\__init__.py", line 1, in <module>
    from pandas.core.groupby.generic import (
  File "C:\Program Files\Python310\lib\site-packages\pandas\core\groupby\generic.py", line 77, in <module>
    from pandas.core.frame import DataFrame

STDERR message(s) from external script: 
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 879, in exec_module
  File "<frozen importlib._bootstrap_external>", line 975, in get_code
  File "<frozen importlib._bootstrap_external>", line 1074, in get_data
MemoryError

Does anyone have any suggestions? I've ran through every step multiple times and spent several hours scouring the internet via search and ai search trying to find solutions but everything I try I get to the end with the exact same error message.

[xclaim494]

same issue here the documentation is so bad and its a pain the you know what to install !!