Re: SQL Server EM/Query Analyzer Access

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/27/05 

Date: Sat, 28 May 2005 02:35:46 +0530

Hi,

No, you can't restrict a user from the usage of QUERY ANALYZER/ ENTERPRISE
MANAger if they have access to your network
with SQL Server Login and password. In this case ensure that the partcular
sql server login do not have more rights.

Thanks
Hari
SQL Server MVP

"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
>
>

Relevant Pages

  • Executing SP freezes other clients
    ... In my accounting system which uses SQL Server with ODBC when the manager ... other clients' PCs who are using POS Screen almost freeze. ...
    (microsoft.public.sqlserver.programming)
  • Re: .udl file?
    ... OK button and then seeing the "SQL Server Login" prompt, ... Connection" checkbox is checked on which would explain why the initial ...
    (microsoft.public.access.externaldata)
  • Re: sqlserver connection - need help desperately!
    ... > You are connecting to a remote SQL Server ... > The SQL Server accepts both Windows and SQL Server authentication. ... > SQL Server login that's authorized to use your database. ... > the ASP.NET account in the SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Authenticating in SQL Server via MS Access 2002
    ... account and this account will be used by Access to authenticate with ... > 1.Database is on SQL Server 2000 ... > SQL using Windows authentication. ... > it is then that they are asked for their SQL Server login. ...
    (microsoft.public.access.externaldata)
  • Re: Windows Services and SQL Server
    ... SqlClient class with a regular SQL Server login? ... because you're running the service as local system (or ... to run the service under a differnt user account which does have ...
    (microsoft.public.dotnet.languages.csharp)