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://video2.skills-academy.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,670 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 26,706 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".

  2. Louise M 1 Reputation point
    2024-09-05T23:23:10.21+00:00

    I could not get the download working for R so downloaded them all manually and installed from local files.

    0 comments
  3. Louise M 1 Reputation point
    2024-09-05T23:24:25.1233333+00:00

    Weird - I can't except my own answer. Anyway, its all working.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.