SQL Anywhere on Amazon cloud services

[Former Member]

I wanted to try out running sql anywhere on amazon cloud services. When setting up the firewall, i find that amazon only has preconfigured application ports available, and no sybase products are listed. MS SQL Server and MySQL both are, but neither sql anywhere nor ASE are listed.

Does anyone know if this intentional and the limit to what the sybase product offering will be on amazon?

[Former Member]

Although there is no pre-configured entry in the Amazon Console for SQL Anywhere, you can manually open any port range that you like. If you choose the "Custom" entry in the AWS Management Console, you choose the range that will be opened up. By default the SQL Anywhere server starts on port 2638. However, since this is not guaranteed, you will want to explicitly specify which port your database is running on at startup. You can do this using the -x switch.

For example, to force the server to start on 2638 you can use:

dbsrv11 -x tcpip(port=2638) mydatabase.db

Then, open up custom port range (PROTOCOL=TCP, FROM=2638, TO=2638, SOURCE=0.0.0.0/0)

More information can be found at http://dcx.sybase.com/index.html#1101en/dbadmin_en11/serverport-network-conparm.html