installation error new SQL Server Failover Cluster

Question

Hi expert,

i've got error message below when installing New SQL Server Failover Cluster Installation option

"The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance due to the following error: 'The network address is invalid."

any advice?

Greta thanks & appreciation for all replies

Warm Regard.

Answer 1

To add a node to an existing SQL Server failover cluster instance run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node to manage the other nodes.

I am assuming you are configuring node on different subnet. See this link for configuring nodes on different subnet.

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/sql-server-multi-subnet-clustering-sql-server?view=sql-server-ver16

Answer 2

Hey,

Did you prestage cluster accounts? This procedure is needed to enable a user or group to create a failover cluster when they do not have permissions to create computer objects in AD DS. https://learn.microsoft.com/en-us/windows-server/failover-clustering/prestage-cluster-adds

Here is a nice troubleshooting guide of the error you are facing. https://techcommunity.microsoft.com/t5/sql-server-support-blog/the-given-network-name-is-unusable-because-there-was-a-failure/ba-p/318661

You should also check that you have DNS entry of the cluster and it resolves to the right IP.

Might also help: https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

Answer 3

Hi @Urbel,

Did you mean that you want to install a new SQL server failover cluster in your environment, you got this error during instance configuration as below screenshot?

The setup program uses the Windows API NetServerGetInfo to validate the network name. Please make sure the network name you are using is unique and not already in use on the network. Please validate that there is no stale entry in the DNS server that is pointing this network name to a different IP address. If possible, clean up all entries related to this network name from the active directory and other name resolution servers like DNS.

Please run the SQL server setup file as administrator to configure SQL server FCI.

Please refer to the MS blog The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance to get the detail troubleshooting steps.

 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.