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

consequence of changing service account

if you changed service account from

what precautions should you take?

what may fail after the switch?
2 Solutions
Ramesh Babu VavillaCommented:
Domain account This option sets the service to use a standard domain account with privileges you configure. Use domain accounts when the server requires access to resources across the network, when you need to forward events to the application logs of other systems, and when you want to configure e-mail or pager notifications.
Local system account This option provides administrative privileges to SQL Server on the local system but no privileges on the network. If the server requires resources only on the local server, use a local system account. Use local system accounts when you want to isolate SQL Server and restrict it from interacting with other servers.

sql server 2008 administrator pocket consultant by willam
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
When the installer is informed of a domain service account, it makes several modifications to the security on that account on the local system.  You can go back later, and add those permissions before assigning a new service account.

What may fail, depending on the service, might include:
  The service not being able to start because it doesn't have rights to the executable.
  The service starting, and immediately stopping, for a wide variety of reasons.
When you do make the change, you'll want to do so in the SQL Configuration Manager, not in the Windows Services control panel applet.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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