Can SQL run as a domain user?

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 13, 2003 at 8:05 am

  #58562

  My sysadmin and I are trying to find out if MS SQL Server can be started and run as a domain user vice an administrator account. Has anyone done this (Set MSSQLServer service to be a domain user account)?

  Does anyone know of the pros and cons of doing this?

  -SQLBill

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  January 13, 2003 at 8:17 am

  #446163

  I have most of our SQL Servers running as domain users, they are Local Admin at each SQL Server. But basically Domain Users otherwise, There are a couple of additional abilities added, Log On as Service, ...

  But still just Domain User.

  KlK, MCSE

  
  KlK

• well0549

  SSCrazy

  Points: 2259

  More actions

  January 13, 2003 at 8:18 am

  #446164

  You should do this. Look in BOL for Service accounts.

  You could need it for :

  ·Remote procedure calls

  ·Replication

  ·Backup to Network Drives

  ·SQL Mail

  ·Linked Servers

• gfahrlander

  SSCommitted

  Points: 1888

  More actions

  January 13, 2003 at 8:29 am

  #446166

  I use a domain account for my installations (32-SQL2K/10-SQL7/1-SQL6.5). Had to have Network Security create a account with password that never expires and add it to a domain group that has admin rights on my servers.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 13, 2003 at 12:06 pm

  #446196

  Thanks everyone for the information. I just found (via BOL) that I can't set my MSSQL service to run as anything but Administrator. Per BOL, when creating or maintaining MS SQL 2000 on a failover cluster you must set the service to run as Administrator (local admin is good enough, but it must be admin privileges).

  -SQLBill