Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
justin
Starting Member
7 Posts |
 Posted - 2003-01-15 : 17:12:16
|
| During installation, SQL Server asks whether to use the local system account or a domain user account. Which is preferable? I come from a Unix background and security usually dictates that a public service should never run under a user with any real privileges.Is that true here or is the system account fine?(btw, I am very new to Windows administration) |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2003-01-15 : 18:06:07
|
| I would recommend using a domain account. Not a user account but a service account setup up specifically to run SQL Server. By doing this you can tighten down the permissions that need to be given to that account. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-15 : 18:09:25
|
| It is recommended that you use a domain account if you are going to need the SQL Server to talk to another SQL Server (for Log Shipping, jobs, etc...). If this will be a standalone SQL Server, then use a local account, but I would still go with a domain account.Just because an account is a domain account doesn't mean that it has that many permissions.Edited by - tduggan on 01/15/2003 18:11:10 |
|
|
|
neil
Starting Member
29 Posts |
Posted - 2003-01-17 : 03:38:41
|
| What permissions does the domain account need to run the sql server service ? Thanks |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-17 : 14:24:13
|
| The required permissions are granted to the account you specify during install and when you change the account via Enterprise Manager. However here's a KB article that explains what they are [url]http://support.microsoft.com/?id=283811[/url]HTHJasper SmithEdited by - jasper_smith on 01/17/2003 14:25:25 |
|
|
|
|
|
|
Domain Account or Not?