Is UDP needed for SQL Anywhere?

[former_SQLA_member1694877]

Hello,

I am configuring the firewalls for a set of SQL Anywhere v17 High Availability servers. I, of course, have the ports open for TCP but do I also need to configure to allow UDP? Server access with the ports only allowing TCP are working but are there any circumstances, perhaps for use of one of the supporting tools, where UDP needs to be allowed also?

Thank you.

[ian_mchardy · Accepted solution]

UDP is not required by SQL Anywhere, however, in some cases UDP is used to find the server when connecting. You can configure your connection strings to not use UDP if all connection strings from clients and mirror server configuration (for example, with CREATE MIRROR SERVER connection_string server option) specify HOST=host:port.

See http://dcx.sap.com/index.html#sqla170/en/html/3bcaf8366c5f101483eafcd85cddb0e5.html*loio3bcaf8366c5f...

Kind regards,

Ian

[former_SQLA_member1694877 · Accepted solution]

Thanks for the prompt reply Ian!