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?

asked 08 Jun '10, 13:15

Mike's gravatar image

Mike
71111
accept rate: 0%


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

permanent link

answered 11 Jun '10, 20:14

Eric%20Farrar's gravatar image

Eric Farrar
91121320
accept rate: 30%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×8
×4
×2
×1

question asked: 08 Jun '10, 13:15

question was seen: 1,492 times

last updated: 11 Jun '10, 20:14