Restricting access via LAN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew - 24 May 2006 22:43 GMT

We have a third-party SQLS 2000 based client-server system where the client
software uses SQLS logins (not LAN logins) to access the database. This
opens up the risk of users using tools like MS Access, MS Query, etc to
access the database directly rather than through the client software.

Is there a way of restricting access so that only connections from the
client software will work? Note we are very restricted on what can be done
with the application itself as it is third-party. We need to put something
in place on the server.

TIA
Andrew

Reply to this Message

Sue Hoegemeier - 25 May 2006 00:32 GMT

Unfortunately, not really. You can implemented checks for
users that will kill the process after the fact if they
aren't logged in with whatever application. But that's after
they have logged in.

-Sue

>We have a third-party SQLS 2000 based client-server system where the client
>software uses SQLS logins (not LAN logins) to access the database. This
[quoted text clipped - 8 lines]
>TIA
>Andrew

Reply to this Message

Andrew - 26 May 2006 01:28 GMT

Thanks Sue - you have confirmed what I thought to be the case. Always worth
asking though.

> Unfortunately, not really. You can implemented checks for
> users that will kill the process after the fact if they
[quoted text clipped - 16 lines]
>>TIA
>>Andrew

Reply to this Message