Types of startup accounts

  • 12:49 AM
  • 2 comments

Local User Account: This user account is created in your server where SQL Server is installed, this account does not have access to network resources.
Local Service Account: This is a builtin windows account that is available for configuring services in windows. This account has permissions as same as accounts that are in the users group, thus it has limited access to the resources in the server. This account is not supported for SQL SERVER and AGENT services.

Local System Account:
 This is a builtin windows account that is available for configuring services in windows. This is a highly privileged account that has access to all resources in the server with administrator rights.
Network Service Account: This is a builtin windows account that is available for configuring services in windows. This has permissions to access resources in the network under the computer account.
Domain Account: This account is a part of your domain that has access to network resources for which it is intended to have permission for. It is always advised to run SQL Server and related services under a domain account with minimum privilege need to run SQL Server and its related services.
Where can you see the Local System, Local Service and Network Service accounts? These are windows in-built accounts that are part of the operating system and assigned to the users, you cannot use the account to login to the system, these accounts are meant to be used for securing and authentication mechanism.

2 comments:

{ Anil } at: August 29, 2012 at 9:53 PM said...

Hi Prakash ,

Please explain with an example.It is good blog but with an example it would be more clear.

{ Prakash chheatry } at: August 31, 2012 at 12:40 PM said...

Sure, Please read the next blog coming up on tuesday with complete security of sqlserver

Post a Comment

 

Copyright © 2010 SQL Cached, All Rights Reserved. Design by DZignine