Re: Securing Microsoft SQL Enterprise Manager

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: The Poster Formerly Known as Kline Sphere (.)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 21:30:19 +0100

>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