[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • 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.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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