Results 1 to 2 of 2

Thread: SQLServer service login /Sysadmin rights?

  1. #1
    Senior Member
    Join Date
    Aug 2001

    SQLServer service login /Sysadmin rights?

    Hi all,

    This may be another Microsoftism, but I was going though our primary domain controller looking at user accounts and I noticed there were some SQL Server accounts one was called sqlsvc and I noticed it is in the domain admin group!

    Can this really be nesessary? Has anyone had experience with this.

    I am wondering what will happen if I remove sqlsvs from the group or if I change the password what it will screw up.

    Any feedback would be welcome =)
    Atlanta, GA

  2. #2
    Senior Member
    Join Date
    Nov 2001
    It should only be there if the SQL server needs to access a file on a regular basis (for backups across the network, and etc). It shouldn't need its own admin-level user account, just write privs to the dir that it backs up to.
    Chris Shepherd
    The Nelson-Shepherd cutoff: The point at which you realise someone is an idiot while trying to help them.
    \"Well as far as the spelling, I speak fluently both your native languages. Do you even can try spell mine ?\" -- Failed Insult
    Is your whole family retarded, or did they just catch it from you?

Posting Permissions

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