SQL Server 2017 Machine Learning Services – Offline Installer Issue

Situation

You’re trying to install SQL Server 2017 Machine Learning Services onto an existing SQL Server 2017 installation.
You select the checkboxes for R en Python because that’s how you roll.
And off you go to the next screens!

Issue

That’s when you remember it… Your server isn’t connected to the internet!
Pretty normal, but in your enthusiasm you completely forgot that SQL Server needs to download some binaries for the R and Python components you so desperately want on your precious machine!

Luckily, the installer comes to your rescue and shows you where to download those binaries it needs.
Turns out however… This link only is for one R component and the installer won’t let you pass to the next screen!

Solution

Microsoft has a complete list of all possible components you could ever want to install while offline. From SQL Server 2016 RTM, over to SQL Server 2017 CTP 1 and up to SQL Server 2017 CU 1.

You can find the full list over at docs.microsoft.com: https://docs.microsoft.com/en-us/sql/advanced-analytics/r/installing-ml-components-without-internet-access

Hopefully, next time you’re installing ML Services, this will save you some time searching for why that “Next” button won’t become active.

 

Data science with Microsoft – Personal BI to Personal Data Science

How do you go from Personal BI to Personal Data Science?
Isn’t Data Science only for those rare unicorns that are smarter than most of us combined?
Can we even democratize Data Science within the enterprise?Personal BI & Data Science

Kimberly Hermans (twitter) and I presented on this topic last week, the 27th of November, at the Microsoft UK office. Jen Stirrup (blog | twitter) had organized a great event for the community there: “Data Culture Day London – Power BI Edition“.

This is a write-up of the presentation “Personal BI to Personal Data Science”, hopefully it will make you want to attend the presentation.
Currently you can still attend it at the next SQL Server Usergroup event in Belgium on the 8th of December.
After that date, take a look at my calendar to see if I’m delivering this session somewhere else.

Read on!

Read moreData science with Microsoft – Personal BI to Personal Data Science

%d bloggers like this: