What is involved in setting up R Services in SQL Server 2016?

While installing SQL Server 2016 you can install all components related to R Services (in-database). After installing you need a few more additional steps required to enable R Services feature like cconfiguring accounts and giving permissions to specific objects etc.

These are the steps:

Step 1: Install R Services (In-database) on SQL Server 2016

Step 2: Enable R Service and Verify that Local R Script Execution Works

Step 3: Enable Implied Authentication for Launchpad Accounts

Step 4: Give Non-Admin Users R Script Permissions-Grant Permission script

For further details go here:
https://msdn.microsoft.com/en-us/library/mt696069.aspx
For details of Step 1 go here:
http://hodentekmsss.blogspot.com/2016/06/installing-sql-server-2016-developer.html
For details of Step 2 go here:
http://hodentekmsss.blogspot.com/2016/07/problem-enabling-r-service-in-sql.html
http://hodentekmsss.blogspot.com/2016/09/enabling-r-service-and-verifying-local_6.html

What R language items are installed when you install SQL Server 2016?

R langugage support featured in SQL Server the  first time in SQL Server 2016. There were items  at isntallation time that explicitly shows the items.

Ritems_00 in help

The following items (RServer and R Services) were installed according to the above choice.

When you install SQL Server 2016 Developer you will be able to use the following:



SQL@2K16_defaultInstall

Also in the SQL Server Installation Center you can install a stand-alone Microsoft R Server by clicking the link in the installation center, if for some reason you do not find the Microsoft R Server in your search.

RServer_00

After installing SQL Server 2016 Developer edition you should be able to find the R Server related folders/files here:

 

R_Folder

R is Power full.
 
R is supposed to be the most powerful language when it comes to statistical processing of a large amount of data; machine learning and graphics. It is open, that means world is the player. Microsoft got into R for these strengths but still there were challenges when it comes to volume of data and deployment scenarios. The open software was further tuned for SQL Server to include in Microsoft R Server.

The Microsoft R product consists of the following:

• Microsoft R Server
• Microsoft R Client
• Microsoft R Open
• SQL Server R Services

You should jump into R if you are going to work with databases and specially analytics. Analytics is the future! believe me.