SQL Sever 2012 Setup Error – Rule ‘Setup Account Privileges’ Failed

KB ID 0000976

Problem

When trying to install SQL Server 2012 (Standard c/w SP2). This popped up;

Rule 'Setup account privileges' Failed

Rule Check Result
Rule "Setup account privileges" failed.
The account that is running SQL Server Setup does not have one or all of the following rights: the right to back up files and directories, the right to manage auditing and the security log and the right to debug programs. To continue, use an account with both of these rights. For more information, see
http://msdn.microsoft.com/en-us/library/ms813696.aspx,
http://msdn.microsoft.com/en-us/library/ms813959.aspx and
http://msdn.microsoft.com/en-us/library/ms813847.aspx.

As I was logged in as the domain administrator, (yeah I know, but it’s my test network). I was confused.

Solution

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

Windows Run admintools

2. Launch ‘Local Security Policy’.

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.

backup files and directories right

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

manage auiting and security log right

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

debug programs right

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

SQL Setup Account privileges

 

Related Articles, References, Credits, or External Links

NA

Author: Migrated

Share This Post On