SQL Server 2025 Preview - Where is Python and R Language support

Question

SQL Server 2025 Preview - Where is Python and R Language support

Peter Bishop 231

I'm looking at the SQL Server 2025 Preview and am wondering if "Machine Learning Services (In-Database)" (i.e. Pyton and R Language support) is no longer an available feature. Or am I just missing a selection box during the installation? Thanks.

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Erland Sommarskog 129.1K MVP Volunteer Moderator

I haven't checked what applies specifically to SQL 2025, but already SQL 2022 shipped without R and Python, so there is nothing new here.

The reason Microsoft made this change is that new versions of R and Python come out more often than new versions of SQL Server, so it would not be a good thing to ship versions of R and Python that are outdated or soon will be.

For how to add Python and R to SQL 2022, you can for instance see this blog post from Greg Low: https://blog.greglow.com/2024/03/04/fix-getting-r-and-python-to-actually-work-on-sql-server-2022/. It should be applicable to SQL 2025 as well.

Peter Bishop 231 Reputation points

2025-11-19T13:30:25.2133333+00:00

Thanks for that. We haven't implemented SQL 2022 so this is the first time I've come across it.

Peter Bishop 231

Successfully followed those instructions and 'R' worked straight off. However, running a simple Python script resulted in:

Msg 39012, Level 16, State 14, Line 0
Unable to communicate with the runtime for 'Python' script for request id: 9BE46356-6D6A-4FE0-97C2-8CE9A4DD03C1. Check the requirements of 'Python' runtime.
STDERR messages from external script: 
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "D:\Program Files\Python310\lib\site-packages\revoscalepy\__init__.py", line 127, in <module>
    from .computecontext.RxInSqlServer import RxInSqlServer
  File "D:\Program Files\Python310\lib\site-packages\revoscalepy\computecontext\RxInSqlServer.py", line 13, in <module>
    import dill
  File "D:\Program Files\Python310\lib\site-packages\dill\__init__.py", line 26, in <module>
    from ._dill import (
  File "D:\Program Files\Python310\lib\site-packages\dill\_dill.py", line 171, in <module>
    FileType = get_file_type('rb', buffering=0)
  File "D:\Program Files\Python310\lib\site-packages\dill\_dill.py", line 164, in get_file_type
    f = open(os.devnull, *args, **kwargs)
PermissionError: [Errno 13] Permission denied: 'nul'

This suggests an issue accessing the nul device but I haven't found anything online to suggest a fix or what account requires the access.

Has anyone seen this error before?

Peter Bishop 231 Reputation points

2025-12-02T09:47:05.6366667+00:00

If you get this error, the solution can be found here:
https://learn.microsoft.com/en-us/answers/questions/5635812/sql-server-2025-unable-to-run-python-scripts

Answer 2

In SQL Server 2025 Preview, Machine Learning Services (In-Database) is still available, which includes support for Python and R. However, it is important to ensure that you select the appropriate options during the installation process. Specifically, you need to choose the Machine Learning Services and Language Extension option to enable the execution of Python and R scripts within SQL Server. Additionally, you should select the options for R and Python to include the necessary packages and interpreters.

If you are not seeing the selection box, make sure you are following the installation steps correctly and that you are using a version of SQL Server that supports these features.

References:

Share via

SQL Server 2025 Preview - Where is Python and R Language support

1 additional answer

Your answer