I am using SQL Anywhere 9.0.2 version.

Problem: I can access remote DB using dbisql utility by providing HOST as remote system ip address.

I am starting database using dbsrv9.exe utility.

Is there any way to restrict the remote access on this database?

Thanks in advance

asked 04 Jul '11, 02:55

Vineet's gravatar image

Vineet
1405814
accept rate: 25%

edited 15 Mar '13, 17:20

Mark%20Culp's gravatar image

Mark Culp
23.2k9132272


Do you mean you want to run the database server (dbsrv9) instead of the personal engine (dbeng9) but want to allow only local access - i.e. prevent client connections from other machines?

Then this Q&A does exactly answer your question.

permanent link

answered 04 Jul '11, 03:51

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665
accept rate: 32%

Thanks Volker for the reference.

From this, I can assume that dbsrvX.exe doesn't provide any way to restrict remote access(using switch or by any other mean).

(05 Jul '11, 05:04) Vineet
Replies hidden
1

No, that's not my conclusion.

In order to restrict remote access, you can either

  • use dbengX or
  • use dbsrvX with the -x tcpip{localonly=yes} option.
(05 Jul '11, 05:20) Volker Barth

AFAIK, a third possibility is to restrict TCP/IP connections altogether by

  • use dbsrvX with the -x none option.

That enables only shared memory connections and won't enable local TDS connections (e.g. jConnect) and may not support all variants of connections between local clients and services/terminal services, cf. the docs.

(05 Jul '11, 08:55) Volker Barth
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:

×99
×26

question asked: 04 Jul '11, 02:55

question was seen: 1,760 times

last updated: 15 Mar '13, 17:20