none
Domain service accounts for R services in SQL 2016 RRS feed

  • Question

  • Is it possible to use domain service accounts instead of the local MSSQLSERVERXX accounts in the SQLRUserGroup? As I understand the MSSQLSERVERXX needs 'Log on locally' and that is blocked by GPO.
    Tuesday, May 9, 2017 10:00 AM

All replies

  • I am not sure whether the MSSQLSERVERXX need "Log on locally", and I am pretty sure that they cannot be replaces with domain service accounts.

    See here: https://docs.microsoft.com/en-us/sql/advanced-analytics/r/configure-and-manage-advanced-analytics-extensions, and here: https://docs.microsoft.com/en-us/sql/advanced-analytics/r/modify-the-user-account-pool-for-sql-server-r-services for more info about this.

    Niels


    http://www.nielsberglund.com | @nielsberglund

    Tuesday, May 9, 2017 3:35 PM