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.)