SQL Server 2019 - Instance name "MSSQLSERVER" is already in use. To continue specify a unique instance name.

Question

I followed these steps to add ML services(R & Python) and i try to run setup and skip the installation rules to install MSSQL 2019 to an existing failover cluster instance. But i received this error:

I have read the documents:
SQL Server Machine Learning Services (Python and R) on Windows
How to add reporting services to an existing sql server clustered instance

I executed the below command at the Windows command prompt to start SQL Server setup on the active node.

 Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install  

I stopped the mssql services and i executed the installation again, but not work.

Answer 1

@Kesslex

You can add extra command line switches like those described here to point it to the cluster:

Windows 2016 Server Core - Add node to a SQL Server Failover Cluster

You can also try doing it via the GUI SQL Setup Wizard and choose Add a Cluster Node. If needed, this utility can also run a SQL Features Discovery to see what's installed on the box and ensure it's not conflicting with another instance.

Add or remove nodes in a failover cluster instance (Setup)

Please upvote or accept this thread as answered if it's helpful, thanks!

Answer 2

Hi @Kesslex ,
According to your error code, I found an article that might be helpful, pls check it out. If it's not helpful, pls let me know.
https://poshelp.robotill.com/InstallError84B30002.aspx#:~:text=If%20you%20get%20the%20error%20code%2084B30002%2C%20858C0014,settings%20because%20the%20install%20did%20not%20complete%20normally.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi @Kesslex ,
How about the problem? :)

Answer 4

Hi @Kesslex
I'm sorry that it seems like the problem is worse than I had thought. If it is convenient to you pls show me the SQL installation error log:
The location:
And I also want to check the windows error log.
You can type invent view in the search box and you can find the error information in this location:

Answer 5

to install MSSQL 2019 to an existing failover cluster instance.

It's not supported to add features to an existing FC SQL Server installation. You would to remove all cluster features first.

Instance name "MSSQLSERVER" is already in use.

By the error message you tried to perform a new installation as default instance (instead of "Add feature ..."), which already exists; that don't work.