October 12, 2007 at 5:23 pm
Hi,
I have virtual cluster name as SQLET01.
Is it possible to have virtual sqlserver name as SQLET01?
It is an Active Passive cluster on Windows 2003.
Thanks,
R
October 13, 2007 at 10:38 am
The virtual SQL Server has a different IP address from the cluster itself. Network names, such as SQLET01, are resolved into IP addresses through DNS. A single network name, such as SQLET01, cannot resolve to two different IP addresses.
The SQL resource group and the cluster resource group must have separate network names owned by those resources.
-Eddie
Eddie Wuerch
MCM: SQL
October 14, 2007 at 2:41 am
Great Info!
Thanks a lot for your explanation.
Regards..
R
October 15, 2007 at 3:34 am
Eddie Wuerch (10/13/2007)
A single network name, such as SQLET01, cannot resolve to two different IP addresses.
well actually it can resolve to more than one IP ...
Take a look at this nslookup:
[font="Courier New"]C:\>nslookup http://www.microsoft.com
Nicht autorisierte Antwort:
Name: lb1.www.ms.akadns.net
Addresses: 207.46.192.254, 207.46.193.254, 207.46.19.190, 207.46.19.254
Aliases: http://www.microsoft.com, toggle.www.ms.akadns.net
g.www.ms.akadns.net[/font]
But while your machine in the cluster dioes have multiple IP-adresses bound to each adapter:
[font="Courier New"]C:\>ipconfig
Windows IP Configuration
Ethernet adapter Heartbeat:
IP Address. . . . . . . . . . . . : 192.168.151.142
Ethernet adapter LAN:
IP Address. . . . . . . . . . . . : xx.xx.7.105
IP Address. . . . . . . . . . . . : xx.xx.7.104
IP Address. . . . . . . . . . . . : xx.xx.6.142[/font]
the SQL Service is only bound to one address:
[font="Courier New"]C:\>netstat -an | find "LIST" | find "1433"
TCP xx.xx.7.105:1433 0.0.0.0:0 LISTENING[/font]
which means that any connection tageted to any of the other IP adresses will not get a connection.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply