Re: Securing Microsoft SQL Enterprise Manager

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

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

Date: Thu, 22 Jul 2004 02:28:11 -0700

Thanks a million Kline for all your posts. You have helped me solve the problem. I tried installing SQL Server 2000 and discovered the Select Components Screen and was to install without installing Enterprise Manager. I have been seeing it during other installations I have been doing but had been over looking it.

Once again thanks a million for just being there. My next problem is on SQLmail. i would send a different post on it. i would appreciate your contribution.

Thank you.

Best regards, 

-- 
Disney
"The Poster Formerly Known as Kline Spher" wrote:
> >The problem is restricting some users and granting some
> > access to MMC on a Local Computer.
> >
> >What do you say I should use to restrict access to SQLmmc.dll? 
> >Is it Active Directory or ACLS? If is either of the two, 
> >please give me an idea on how to go about it.
> 
> Right, first of all why are the client tools installed on these users
> machine? If the tools are not required by any user, uninstall them.
> 
> If you only have few users, it's easiest to connect to each users
> workstation and change the permissions of the sqlmmc.dll manually to
> allow access to only those that require it. If you have hundreds of
> users, you may want to consider writing a simple script to change the
> file permissions and firing the script as part of a one off logon
> process, however such a technique requires that the sql server tools
> directory be located in same place for all users.
> 
> Kline Sphere (Chalk) MCNGP #3
>

Relevant Pages

  • Re: Securing Microsoft SQL Enterprise Manager
    ... >What do you say I should use to restrict access to SQLmmc.dll? ... >Is it Active Directory or ACLS? ... you may want to consider writing a simple script to change the ... file permissions and firing the script as part of a one off logon ...
    (microsoft.public.cert.mcdba)
  • Re: Need assistance badly!
    ... I have tried cobbling together a script that does this, ... I would use ADO in a VBScript program to retrieve all users with the ... Dim objRootDSE, strDNSDomain, strQuery, adoRecordset, strName, strCN ... adoConnection.Open "Active Directory Provider" ...
    (microsoft.public.scripting.vbscript)
  • Re: Another Newbie
    ... I need a script that will give me a list of all users who's ... ' Use ADO to search Active Directory. ... Set adoConnection = CreateObject ... ' Filter on user objects that have password never expires flag set. ...
    (microsoft.public.windows.server.scripting)
  • Re: Operations Masters
    ... Run diagnostics against your Active Directory domain. ... Run dcdiag, netdiag and repadmin in verbose mode. ... If you download a gui script I wrote it should be simple to set and run ...
    (microsoft.public.windows.server.active_directory)
  • Re: Disable/Delete unused workstations
    ... This script will remove inactive machine accounts in Active Directory ... > is there a way to automatically disable or delete workstations not used in ...
    (microsoft.public.win2000.group_policy)