Deny Access to Enterprise Manager

From: Gary (garyt0dd_at_hotmail.com)
Date: 02/27/04 

Date: 27 Feb 2004 01:20:17 -0800

I have 2 Sql servers, one is production and one is test both set up
with mixed mode due to application requirments. User need access to
the test server through Enterprise Manager, but they can also register
the production server. How can I stop them accessing the production
server through Enterprise Manager wbut still authenticate to it
through the application??

Regards.

Gary

Relevant Pages

  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)
  • Re: test environment windows 2003
    ... an authorative restore after the demote and system state restore. ... This document was prepared for the building of a copy of the production ... Remove the physical cable for the new pc and build the member server ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Homegrown synchronization
    ... copying the zip file sitting there on the server to ... It is a filecopy of the zipped backend file from the server to the ... with the server whose SyncApp zips ups the production backend file ...
    (microsoft.public.access.replication)
  • RE: how analyze malfunctioning asp.net application?
    ... a product server, correct? ... unhealthy and teh worker process will be recycled. ... production debugging in your environment. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: ISA/VPN difficulty
    ... W2K/ISA/VPN server and replacing it. ... The current one (production) works fine in terms of ISA and VPN ... The new machine does everything fine EXCEPT allow clients to do ...
    (microsoft.public.isa.vpn)