Can SQL run as a domain user?

Question

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

kknudson SSCarpal Tunnel Points: 4986 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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 · Answer 4

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