Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11

    Unanswered: Demoting a service account

    It has recently come to my attention that the service account we use to run our SQL Servers is in fact a domain admin. For various reasons, I am planning on demoting the service account from domain admin to domain user. It will remain as a local admin on all of the SQL Server boxes, naturally.

    My question is has anyone out there ever done this before, and are there some fiddly bits that domain admins get policy-wise that the service account may lose in the demotion? I am thinking about having a new account created to test things out, but I am concerned some of the more elaborate servers (think clusters) are going to have some other requirements that I can not think of.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Do any of your jobs etc access anything other than SQL boxes e.g. text files?

    *shrug*
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Newp .

    I may just go for creating a brand new account. At least I can test that in the development environment, rather than go for the "one giant leap" strategy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •