Cheat Sheet–Installing In-Database R on SQL Server 2016

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.

https://msdn.microsoft.com/en-us/library/mt696069.aspx

Advertisements
This entry was posted in Database Administration and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s