"Set up Account Privileges" Failure when Installing Microsoft SQL Server 2014

Anonymous
2022-03-04T18:28:42.727+00:00

When i attempt to install Microsoft SQL Server 2014, during set up I get a Failure notification for "Setup account privileges". Although the error links me to several websites, I can't figure out what I'm supposed to do to fix this issue. ![180255-installation-error.jpg][1] [1]: /api/attachments/180255-installation-error.jpg?platform=QnA

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2022-03-04T22:34:20.277+00:00

    When you select a service account for SQL Server in the Setup wizard, Setup attempts to assign this accounts the permissions needed. If this fails, this may be due to that you don't have enough permissions yourself. You are running Setup as a local administrator, aren't you?

    If you are indeed running Setup as an administrator, I don't know why you get this error, but then again, it is more a Windows problem than an SQL Server problem. I would guess that some sort of lockdown has been applied your environment, and you need to talk to your Windows security folks.

    (I'm making the assumption that you are doing this in a corporate environment, and not at home on your private machine.)

    0 comments
  2. YufeiShao-msft 7,056 Reputation points
    2022-03-07T06:02:56.263+00:00

    Hi anonymous user,

    Confirm that the account you are using to install SQL Server has all the privileges required 

    whoami /priv

    to check if the following user right are available

    SeBackupPrivilege
    SeDebugPrivilege
    SeSecurityPrivilege

    https://social.msdn.microsoft.com/forums/sqlserver/en-US/e74e6ebc-61da-448d-971f-6c27118dedf9/rule-setup-account-privileges-failed-the-account-that-is-running-sql-server-setup-does-not-have
    https://learn.microsoft.com/en-US/troubleshoot/sql/install/installation-fails-if-remove-user-right

    If not, please win+R, input gpedit.msc and click OK
    Navigate to Local Computer Policy->Windows settings->Security Settings->Local Policies->User Rights Assignment
    180551-1.png

    Click Back up files and directories-> add the user to this group->apply->ok
    180488-2.png

    Click Debug programs-> add the user to this group->apply->ok
    180556-3.png

    Click Mange auditing and security log-> add the user to this group->apply->ok
    180543-4.png

    And now try installing again

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.