Tuesday, September 6, 2016

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

No comments: