Link to home
Start Free TrialLog in
Avatar of saratcm
saratcmFlag for India

asked on

ServiceAccounts in SQL Server 2005

Hi All,
When we try to install SQL Server, In the service accounts page We will have 2 options to select right1) domain account 2) buit-in system account.

what is the difference in this accounts.

what is the d/f if the SQL Server runs in domain user account or using built in?
ASKER CERTIFIED SOLUTION
Avatar of Bodestone
Bodestone
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of saratcm

ASKER

Hi All,
Thanks for the response
What if I use domain user account? What that particular domain account is having in terms of privileges?
Can u tell me where exactly they differs, In terms of privilege or etc.
I mean if we create built in account all the built in window logins under that server can access that server, right?
but where will this domain accout differ with inbuit account and if we use this sql server will shows that it is running under this domain user account and what is meant by that?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of saratcm

ASKER

Good