lsalih (10/27/2014)
Steve -Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql instances with the same name. Would it be acceptable:
Server1:
SQLSERVER\Instance1
Server2:
SQLSERVER\Instance1
I know if you are on the same network, you use servername\instancename to connect to SQL. I assume the above case it is not acceptable since both server name and instance names are the same even though they are on different nodes. Please correct me if I am wrong.
Thanks,
No, on a Windows network the computername must be unique and usually no more than 15 characters.
You cannot have 2 hosts called SQLServer. You could have the following
Server1:
SQLSERVER1\Instance1
Server2:
SQLSERVER2\Instance1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉