Post reply

Can SQL run as a domain user?

  • 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

  • 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

  • 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

  • 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.

  • 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

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

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