Results 1 to 2 of 2

Thread: SQLServer service login /Sysadmin rights?

  1. June 18th, 2002, 05:08 PM #1
    lucktsm
    lucktsm is offline
    Senior Member
    Join Date
    Aug 2001
    Posts
    117

    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 =)
    Luck--TSM
    Atlanta, GA

    Reply With Quote Reply With Quote
  2. June 18th, 2002, 05:20 PM #2
    chsh
    chsh is offline
    Senior Member
    Join Date
    Nov 2001
    Posts
    1,255
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules