Forum Discussion
genseek_32178
Nimbostratus
NimbostratusVS10 Issue
virtual VS10
pool pl10
destination 10.210.0.210
ip protocol tcp
profiles tcp-default
vlan 10 enable
client - 10.30.45.11
VIP - 10.210.0.210:443
pl10 - 10.210.0.211
client is able to telnet VIP on port 443
But client is connecting VIP via SQL server mgmt studio - it cant connect
client can connect pool member directly via sql studio.
genseek.
2 Replies
Michael_YatesHi Genseek,
SQL Server Management Studio use Port 1433 to connect to a SQL Server. Your Virtual Server is configured for 443.
Try opening up Port 1433 on the Virtual Server IP Address to the server on the same port and see if you problem persists.
genseek_32178Thanks Michael...
You are right..ssms uses port 1433..i used 443 just to avoid using the actual port number...sorry about that. VIP indeed is opened for 1433.
I did a tcpdump when client was accessing VIP on port 1433,and here's what we saw
14:55:25.626243 802.1Q vlan21 P0 10.30.45.11.49448 > 10.210.0.210.1433: S 2503976789:2503976789(0) win 8192 (DF)
14:55:25.626541 802.1Q vlan21 P0 10.30.45.11.49448 > 10.210.0.210.1433: . ack 2045621418 win 256 (DF)
14:55:25.626553 802.1Q vlan21 P0 10.30.45.11.49448 > 10.210.0.211.1433: S 2296223818:2296223818(0) win 4380 (DF)
14:55:25.627153 802.1Q vlan21 P0 10.30.45.11.137 > 10.210.0.210.137: NBT UDP PACKET(137): QUERY; REQUEST; UNICAST
14:55:27.126335 802.1Q vlan21 P0 10.30.45.11.137 > 10.210.0.210.137: NBT UDP PACKET(137): QUERY; REQUEST; UNICAST (DF)
pool member has BigIP as its gwy.
