Forum Discussion

genseek_32178's avatar
genseek_32178
Icon for Nimbostratus rankNimbostratus
Jul 03, 2012

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

 

 

 

 

 

 

  • Hi 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.
  • Thanks 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.