SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

VirtualBox SQL FCI - Given Network Name Is Unusable

The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared storage provided by FreeNAS and a domain controller. All was good at the windows level so I proceeded to install a SQL cluster next but part way through the setup of creating the SQL cluster, I was hit with this error message:

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.'

I couldn't see anything obvious at first. I was using the domain admin account so nowt wrong with permissions. All VM's were up, IP was configured OK, cluster was OK and there nothing of use from the setup log file. So drawing a blank next I hit Google. I eventually came across a VMware based StackExchange post suggesting to remove the Guest additions but one of the comments said that this worked for VirtualBox as well. I was a bit sceptical at first, but I uninstalled the additions software from the guest OS and after rebooting the SQL setup continued perfectly!.. No idea what or why the additions where doing what they were, but problem solved with a relatively issue tweak to the OS. I only had the issue when creating the cluster with the first node. The second node was fine being added to the existing cluster with the guest additions software still being installed. Bizarre, anyway, I hope this helps someone with the same issue.

Enjoy!...

Follow me on twitter @sqlserverrocks

Subscribe to my blog RSS feed

Comment on this or any of my other posts or contact me directly from https://www.olcot.co.uk

Original ServerFault post

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Comments

Leave a comment on the original post [www.olcot.co.uk, opens in a new window]

Loading comments...