"dm4714" <spam@spam.net> wrote in message
news:eR$Pz7vYFHA.3188@TK2MSFTNGP09.phx.gbl...
> Hello -- we have SQL Servers running in a Service Bureau environment. How
> clients frequently use applications at their sites to access our SQL
> Server. Unfortunately, some of our clients are more sophisticated than
> others and know about Enterprise Manager and Query Analyzer, which they
> can try and use outside of our application... assuming they know a
> login/password into SQL.
>
> For those clients that know our SQL Login/Password, and since our
> application doesn't use application logins, is there a way I can block
> EM/Query Analyzer access from our clients and keep it available for us
> internally? Obviously, I cannot block port 1433, but I was hoping I can
> restrict the apps from being used externally.
>
> Thanks
>
>

"dm4714" <spam@spam.net> wrote in message
news:eR$Pz7vYFHA.3188@TK2MSFTNGP09.phx.gbl...
> Hello -- we have SQL Servers running in a Service Bureau environment. How
> clients frequently use applications at their sites to access our SQL
Server.
> Unfortunately, some of our clients are more sophisticated than others and
> know about Enterprise Manager and Query Analyzer, which they can try and
use
> outside of our application... assuming they know a login/password into
SQL.
>
> For those clients that know our SQL Login/Password, and since our
> application doesn't use application logins, is there a way I can block
> EM/Query Analyzer access from our clients and keep it available for us
> internally? Obviously, I cannot block port 1433, but I was hoping I can
> restrict the apps from being used externally.
>
> Thanks
>
>