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 |
satish.ppro
Starting Member
2 Posts |
Posted - 2009-06-02 : 01:45:39
|
I Just want to know the difference between Network Service Account,Local System Account & Dedicated User Account in sql server 2005 |
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-02 : 08:38:29
|
Local System : Completely trusted account, like the administrator account. There is nothing on a single box that this account cannot do and it has the right to access the network as the machine (this requires Active Directory and granting the machine account permissions to perform something)Network Service : Limited service account that is meant to run standard least-privileged services. This account is far more limited than Local System (or even Administrator) but still has the right to access the network as the machineLocal Service : A limited service account that is very similar to Network Service and meant to run standard least-privileged services. However unlike Network Service it has no ability to access the network as the machine.SQL Account: SQL Server controlled and managed in SQL Server for SQL Resources.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
|
|
|
|
|