Re: Securing Microsoft SQL Enterprise Manager

From: Essien (Essien_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 06:50:01 -0700

Thanks a million for your post. I would be most grateful if you could explain how to restrict access to MMC. Secondly, at what point during SQL installation on the client should I restrict Enterprise Manager snap-in ?

Thank you.
Best regards, 

-- 
Disney
"The Poster Formerly Known as Kline Spher" wrote:
> >I need help on how to prevent SQL users without Administrative privileges access to the Enterprise Manager. My SQL is configured for Mixed authentication. 
> >I have a Domain and each user logs in with his/her account and password.
> >
> 
> disallow access the mmc snap in for the users you do not wish to use
> it.
> 
> >Secondly, if I installed SQL Server on a local machine, how do I restrict access to Enterprise Manager to users without Administrative privileges?
> 
> Don't install the snap in on the client machines!
> 
> Kline Sphere (Chalk) MCNGP #3
>

Relevant Pages

  • Re: Securing Microsoft SQL Enterprise Manager
    ... I can restrict access to mmc by enabling the Author mode ie preventing access from command line. ... at what point during SQL installation on the client should I restrict Enterprise Manager snap-in? ... > Used to monitor, record, and support auditing of Microsoft SQL Server ...
    (microsoft.public.cert.mcdba)
  • Re: Users
    ... For Login creation SQL serevr uses the system procedure sp_addlogin, ... automatically picks MASTER database as default if the ... Login to OS using a admin user and connect to SQL server in trunsted mode ... Group" how do I change that password or restrict access through it. ...
    (microsoft.public.sqlserver.server)
  • Re: Login Security
    ... Do i call it from the front using VB or do i use a sql ... >Microsoft Access Developer's Guide to SQL Server ... >>back end is a SQL Server 2K database. ... >>The problem I am having is that I can't restrict access ...
    (microsoft.public.sqlserver.security)
  • Re: Login Security
    ... front end by exeucting the sql statement. ... >>Microsoft Access Developer's Guide to SQL Server ... >>>The problem I am having is that I can't restrict access ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 securing records...
    ... Using a SQL 2000 DB with many tables in a payroll type application. ... Is there a way to restrict access to multiple records ...
    (microsoft.public.sqlserver.security)