How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server

Created by Cheng Kah Poh, Modified on Tue, 29 Nov, 2022 at 11:54 AM by Cheng Kah Poh

Scenario

while install SQL Server may happen Error Occurs ,Rule “Setup account privileges” Failed.

When I clicked on “failed” hyperlink, here is the message.

Solution

If you are running the setup as a local administrator, you require the following user rights for setup to run successfully:

Local Group Policy Object display name	User right
Backup files and directories	`SeBackupPrivilege`
Debug Programs	`SeDebugPrivilege`
Manage auditing and security log	`SeSecurityPrivilege`

1. Well, it turns out I don’t have those rights after all so lets grant them, Windows Key+R > Control admintools {Enter}.

2. Launch ‘Local Security Policy’.

3. Navigate to Security Settings >Local Policies > User Rights Assignment > Back up files and directories > Add in the user that’s being denied > Apply > OK.

4. In the same location locate ‘Manage auditing and security log’ > Add in the user that’s being denied > Apply > OK.

5. In the same location locate ‘Debug programs’ > Add in the user that’s being denied > Apply > OK.

6. Now try again, (remember if you added a group, you will need to log off and back on again.)