SQL Sever Setup Error KB ID 0000976
Problem
When trying to install SQL Server, this popped up;
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 : SQL Sever Setup Error
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.)
Related Articles, References, Credits, or External Links
NA
