Where can I find R Package MicrosoftML to use with SQL Server 2022 Machine Learning Services?

Stefan S 5 Reputation points
2023-01-27T15:40:38.5666667+00:00

Hi,

I am in the middle of the testing phase within migration from SQL Server 2019 to SQL Server 2022. I am using Machine Learning Services in SQL Server 2019 and this part has changed with SQL Server 2022.

I have followed the installation guide here:

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

And successfully installed Python and R, however with the new installation procedure of installing R-4.2.2 for Windows I am missing the library MicrosoftML which was included with the installation procedure for SQL Server 2019.

Where can i find and download that library which is working with SQL Server 2022. This package is referenced in some store procedures which now do not work because of the missing library.

If it is not available for download. Is it possible to use the library wich was included in SQL Server 2019? And in that case how would I go about to install that library?

Thx.
Stefan

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2023-01-30T06:22:53.9+00:00

    Hi Stefan S,

    Beginning with SQL Server 2022 (16.x), runtimes for R, Python, and Java, are no longer installed with SQL Setup. Instead, install any desired custom runtime(s) and packages.

    Here is an article to introduce what's new in SQL Server 2022: https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16#sql-machine-learning-services

    You've found the right guide. Did you download and install the most recent version of R 4.2 for Windows as mentioned in the documentation.

    Please notice this part: https://learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver16#install-runtimes-and-packages

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".