Installing R on SQL Server 2016 is simple. Microsoft’s documentation is great, but this cheat sheet is a handy reference.
Installing In-Database R requires four steps.
1 – Install R Services (In-Database) on the SQL Server instance in question. This does require an acknowledgment that Microsoft Open R will be installed.
2 – Enable External Scripts
3 – Restart SQL Service in order for the enable external scripts change to take effect.
4 – Grant execute any external script permission to appropriate users or roles.
That is it, R is installed. Microsoft provides a nice “Hello, World” example to verify the installation.
The link to Microsoft’s detailed documentation can be found below.