SQL Machine Learning on for SQL 2022

Louise M 1 Reputation point
2024-06-21T00:17:46.2966667+00:00

I'm trying to follow https://learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver16

to install R & Python for SQL 2022.

I can install them just fine, but when it comes to installing the packages mentioned its just not working.

R I get Warning: unable to access index for repository https://CRAN.R-project.org/src/contrib for everything.

Python was going fine up until revoscalepy and I just get ERROR: Cannot determine archive format

Python was a bit tricky as there is no installer for 3.10 any more. I tried 3.12 and I found a copy of 3.10 but they both give the same error.

Any ideas?

I do have to use a proxy. This has been set in IE on the server.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,187 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 25,326 Reputation points
    2024-06-21T03:27:46.52+00:00

    Hi @Louise M

    unable to access index for repository https://CRAN.R-project.org/src/contrib for everything.

    Can you access the URL directly in a web browser?

    Python was going fine up until revoscalepy and I just get ERROR: Cannot determine archive format

    Please verify pip configuration and ensure that the use-wheel option is not set to false in your $HOME/.pip/pip.conf file.

    Best regards,

    Cosmog Hong


    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".