SuperCranium
asked on
Change a SQL Service account
Hi,
I installed an application (Symancte Backup Exec) which auto installed SQL Express.
The default installation installed this with Local System as the account for the instance, and Network Service as the account for the Browser and VSS services.
Ideally, there should be a designated account for these services.
Is it just simply a case of creating a generic service account in AD, and then using SQL Config Mgr to change the service account settings? Will this apply the appropriate SQL rights/permissions to the newly created account.
I installed an application (Symancte Backup Exec) which auto installed SQL Express.
The default installation installed this with Local System as the account for the instance, and Network Service as the account for the Browser and VSS services.
Ideally, there should be a designated account for these services.
Is it just simply a case of creating a generic service account in AD, and then using SQL Config Mgr to change the service account settings? Will this apply the appropriate SQL rights/permissions to the newly created account.
ASKER
if I was to change the account...do I need to give any newly created accounts special permissions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you need to access domain resources, then you can change Local system to a domain account having access to that network resources..
Else Local System would suffice for your SQL Server services..