none
Installing Microsoft SQL 2016 'R' Services on a windows cluster RRS feed

  • Question

  • Hi there

    I am installing R services for the first time on a dev server, but am thinking about where to host it in production. Ideally I would host it on one of my production servers that is configured with AlwaysOn Availability Groups. This server is a participant in a windows cluster due to the requirement of AlwaysOn, but it's not part of a SQL Cluster (or FCI), just a windows cluster. Will R work OK in this environment? I read here that Microsoft R Services are not supported on a failover cluster but i assume they mean a SQL cluster as opposed to a windows cluster:

    https://docs.microsoft.com/en-us/sql/advanced-analytics/r/upgrade-and-installation-faq-sql-server-r-services

    Thanks

    NB

    Friday, August 25, 2017 9:27 AM

All replies

  • I have found the answer in the Microsoft Documentation:

    You cannot install machine learning services on a failover cluster. The reason is that the security mechanism used for isolating external script processes is not compatible with a Windows Server failover cluster environment. As a workaround, you can use replication to copy necessary tables to a standalone SQL Server instance with R Services, or install R Services (In-Database) on a standalone computer that uses Always On and is part of an availability group.

    https://docs.microsoft.com/en-us/sql/advanced-analytics/r/set-up-sql-server-r-services-in-database

    The last sentence indicates that you can install R Services (In-Database) on a server participating in a Windows Cluster because AlwaysOn requires a windows cluster. So it's only a SQL failover cluster that it is not supported.

    Friday, August 25, 2017 12:09 PM