Best practice using EM and Windows Authentification

From: Freddy (fromheretoeternity_at_hotmail.com)
Date: 11/23/04

  • Next message: phonix: "SQL CE 2.0, .NET Framework 1.1 sp 1 / PPC App 2003 Server settings" 
    Date: 23 Nov 2004 08:26:56 -0800

    Hi,

    We have a team of IT people with mixed profiles.
    If we use windows authentification we should be able to see all our
    SQL Servers but with limited rights (readonly).
    If we use a special admin windows account we should be able to have
    full rights.

    How can you accomplish this?

    Allways logged in with my own user account and using EM and Query
    Analyser for readonly stuff and use EM and Query Analyser from time to
    time to change something BUT without logging off on your local machine
    and logging on with your admin account.

    Creating different MMC's, runas,...?
    Can anybody point me in the right direction?

    Thanks!!

    Fred

  • Next message: phonix: "SQL CE 2.0, .NET Framework 1.1 sp 1 / PPC App 2003 Server settings"