SQL Server EM/Query Analyzer Access

From: dm4714 (spam_at_spam.net)
Date: 05/27/05 

Date: Fri, 27 May 2005 15:59:08 -0500

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

Relevant Pages

  • To find SQL Servers in the Network
    ... I want to find the number sql servers available in the network. ... If i am dicovering through software inventory all the clients also counted as server. ...
    (microsoft.public.sms.admin)
  • Re: SQL Server EM/Query Analyzer Access
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > clients frequently use applications at their sites to access our SQL ... > For those clients that know our SQL Login/Password, ... Obviously, I cannot block port 1433, but I was hoping I can ...
    (microsoft.public.sqlserver.security)
  • Port 445 and client installation issues
    ... We've had to block port 445 between sites and we are just now installing SMS ... clients on all machines between sites - can someone provide me the article ...
    (microsoft.public.sms.admin)