SQL Server 2019 - Failed to install Machine Learning Services on a Windows Failover Cluster instance

Jessie G 21 Reputation points
2021-06-17T23:54:19.193+00:00

I followed these steps to add ML services (R & Python) to an existing failover cluster instance of SQL Server 2019 (The installation media was ran on one of the cluster nodes):
106801-image.png
106729-image.png

And received this error:
Rule 'Existing clustered or cluster-prepared instance' failed.

106747-image.png

Does SQL Server 2019 not support adding ML services to an existing failover cluster?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,585 questions
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,066 Reputation points Microsoft Vendor
    2021-06-18T03:07:48.07+00:00

    Hi @Jessie G ,

    >Does SQL Server 2019 not support adding ML services to an existing failover cluster?

    Yes, you are right. When we adding any features to an existing SQL server failover cluster, we will receive the error message that you got.

    But when we create a new SQL FCI, we can select ML service feature. Installing Machine Learning Services isn't supported on an Always On Failover Cluster Instance (FCI) in SQL Server 2017. It's supported with SQL Server 2019 and later.

    Please refer to MS document Install SQL Server Machine Learning Services (Python and R) on Windows.

    You can try to run setup and skip the installation rules to install SQL Server Machine Learning Services in an existing clustered instance.

    Run the below command at the Windows command prompt to start SQL Server setup on the active node. Make sure to run this command after changing the root directory of the command prompt to the location where you have placed the SQL Server setup files.

    Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install  
    

    Please refer to the blog How to add Reporting Services to an existing SQL Server Clustered Instance to get the detail step by step information. Add ML service feature is similar as SSRS.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Kesslex 1 Reputation point
    2022-09-13T19:34:25.343+00:00

    Hi @CathyJi-MSFT ,

    I tried to run setup and skip the installation rule, but i received this error:
    240708-image.png