consequence of changing service account

Posted on 2012-09-19
Last Modified: 2012-10-15
if you changed service account from

what precautions should you take?

what may fail after the switch?
Question by:25112
    LVL 10

    Assisted Solution

    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
    LVL 29

    Accepted Solution

    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

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now