question

JessieG-0714 avatar image
0 Votes"
JessieG-0714 asked Cathyji-msft commented

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

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-general
image.png (129.6 KiB)
image.png (182.0 KiB)
image.png (116.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JessieG-0714,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered

Hi @JessieG-0714,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.