Python with SQL 2022 Enterprise doesn’t work

  • I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured Python. Official Python site let me download only the latest 13.3 version. I followed every step of the article

    https://learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver16

    everything went well and launchpad service is up and running, but when I am trying to test in SSMS, I get this error;

    Msg 39012, Level 16, State 14, Line 0

    Unable to communicate with the runtime for 'Python' script for request id: 894C838B-D99D-4700-9304-8643A4AA8425. Please check the requirements of 'Python' runtime. STDERR message(s) from external script: Failed to find real location of C:\Program Files\Python310\python.exe

    Traceback (most recent call last).

     File "<string>", line 1, in <module> from revoscalepy.computecontext.RxInSqlServer import rx_sql_satellite_pool_call

     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 27, in <module> from . rxLibs.pylink import px_call

    ImportError: DLL load failed while importing pylink: The specified module could not be found.

    I found few articles regarding this issue and everyone seems to be convinced that Python 3.13 is not working with sql 2022 but Python 3.10 does. The problem is that Python 3.10 isn’t available for download even from archives. Any other solution?

  • Failed to find real location of C:\Program Files\Python310\python.exe

    What's the path to the Python executable on your computer?

  • It is C:\Program Files\Python310\

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply