• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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.

0
SuperCranium
Asked:
SuperCranium
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can configure Local System itself if SQL Server service is going to be used only by Backup Exec..
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..
0
 
SuperCraniumAuthor Commented:
if I was to change the account...do I need to give any newly created accounts special permissions?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Not required..
If you need to access Domain resources, provide a Domain account which has privilege to domain resources else create a local user account if you don't want to use Local System..
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now