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 |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2009-11-04 : 05:40:36
|
| Hi there I am looking to change the way our new server boxes are installed. Currently the agent and server services run under the local system account something i am not happy about and i want the new installs to run under a domain account.If i create 2 new domain standard user accounts to run the services from sql2005 adds them to the groups it created on install i think.However is there any special privileges i would need to give the domain accounts for SQL to run correctly?Any ideas would be great.Cheers |
|
|
learnit
Starting Member
6 Posts |
Posted - 2009-11-04 : 07:42:56
|
| Hey, You can learn more on the requiremets using the following linkhttp://msdn.microsoft.com/en-us/library/ms345380.aspx |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-06 : 10:23:29
|
| As per micorosft best practice, sql service account should have only minimum privilege. But in some cases sql agent needs to be run with loacl admin privilege, since it needs to excess specfic folder & need permission to execute certain scripts etc. Test it out with out admin privillge & change laster if required.Make sure to know how you could change the service account. Don't change it from services.msc panel, pls refer the below link.http://sqlserver.in/index.php/administration/35-administration-queries/111-how-to-change-sql-server-service-account.htmlThanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
Server and Agent Domain accounts