SQL Machine Learning on for SQL 2022

Question

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.

Answer 1

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

Answer 2

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

Answer 3

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