Join the Conversation

To sign in, use your existing MySonicWall account. To create a free MySonicWall account click "Register".

SQL dropping connection when in different VLAN

Hi Community.

I'm working on our LAN VLAN segmentation using our SonicWall NSA2700 as router. I have created some VLAN subinterfaces under the same Interface and added policy access rules to communicate them as needed. Everything works fine except SQL based programs. We put SQL (and others) servers in one VLAN and clients accessing to those servers in another. The thing is that they were constantly being disconnected. So I put them back to old VLAN (before segmentation, sql server and clients in the same) and everything went back to normal.

Am I missing something? Everything else (internet connection, shared drivers, printing) works fine with different VLANs scenario, just SQL based connections are being dropped.

Any clue would be appreciated.

Thanks.

Category: Mid Range Firewalls
Reply

Best Answer

  • CORRECT ANSWER
    ITSRBITSRB Newbie ✭
    Answer ✓

    We had such a problem with oracle databases (errors: ORA-12637, ORA-00609). Oracle (since 19c) checks whether the underlying network supports "out-of-bound" packets. This refers to packets with URG flag.

    We have enabled "Allow TCP Urgent Packets" in the access rules (Editing Rule -> Optional Settings -> Allow TCP Urgent Packets) for the Clients who needs it.

    Maybe this will also help you.

Answers

Sign In or Register to comment.