Windows Authentication & Services

From: Mike Perkins (mike_at_cattertonprinting.com)
Date: 05/29/03

  • Next message: gotit: "Windows Authentication & Services" 
    Date: Thu, 29 May 2003 04:25:43 -0700

    I would on the SQL Box, grant her access as service
    ServiceLogonRight, with this then all she needs a program
    to remotly access Services on another machine and she can
    start and stop them as needed without having Domain Admin
    Rights.
    >-----Original Message-----
    >I would like for someone assisting me to be able to login
    >to the domain admin windows login that we have for our
    >2000 sql servers in order to be able to stop/start
    >services on one of our production servers. Is there a
    way
    >for them to do this at their workstation w/o having to
    >completely log out? (I'm asking because I'm not sure our
    >network guys will let us install terminal services and
    >they definitely will not let her be local admin.)
    >Ideally, I'd like her to be able to use a Window's 2000
    >Computer Management session w/o having to log out and log
    >in as a domain admin.
    >.
    >

  • Next message: gotit: "Windows Authentication & Services"

    Relevant Pages

    • Re: SQL account rights
      ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
      (microsoft.public.sqlserver.security)
    • Re: SQL account rights
      ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
      (microsoft.public.sqlserver.security)
    • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
      ... It may have been my SQL ... to restart SQL Agent when SQL Server restarts which I ... I did the install about a month ago as Domain Admin (default install - mixed ...
      (microsoft.public.sqlserver.msde)
    • Services login policies and rights question
      ... Scenario is Windows 2003 Enterprise and SQL Server 2000 Enterprise. ... any SQL Server install on / in a 2003 environment). ... We trying to install today with a sql service domain account added to the ... domain admin group and still wouldn't install. ...
      (microsoft.public.sqlserver.clustering)