Question Re: Restricting access to remote Database - SQL Anywhere 9.0.2 in Technology Q&A

Restricting access to remote Database - SQL Anywhere 9.0.2

Former Member — Mon, 04 Jul 2011 02:55:23 GMT

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

Re: Restricting access to remote Database - SQL Anywhere 9.0.2

VolkerBarth — Mon, 04 Jul 2011 03:51:01 GMT

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.

Re: Restricting access to remote Database - SQL Anywhere 9.0.2

Former Member — Tue, 05 Jul 2011 05:04:50 GMT

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).

Re: Restricting access to remote Database - SQL Anywhere 9.0.2

VolkerBarth — Tue, 05 Jul 2011 05:20:41 GMT

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.

Re: Restricting access to remote Database - SQL Anywhere 9.0.2

VolkerBarth — Tue, 05 Jul 2011 08:55:10 GMT

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.