Symptom
SQL 2012 or SQL 2008 installation failed with access denied or showing the error "setup account privileges" failed
Root cause :
the user account used for the sql installation is missing one of the below access
1. SeBackupPrivilege
2. SeDebugPrivilege
3. SeSecurityPrivilege
How to check if the user account have these access or not :
1. download accesschk.exe from http://technet.microsoft.com/en-us/sysinternals/bb664922.aspx
2. open the command prompt with elevated privilege
3. navigate to the accesschk.exe path in the command prompt
4. run the following command accesschk.exe domain\username *
5. The output will show all the privilege the user have and see if the above three privilege are listed
How to fix the issue :
If any of the above privilege is missing then follow the below steps to add those.
1. click start --->Run ----> gpedit.msc
2. expand local security policy ----> Local policies ----> User Rights Assignment
Double click "Backup Files and Directories Properties" and add user or group if SeBackupPrivilege is missing
Double click "Debug Programs" and add user or group if SeDebugPrivilege is missing
Double click " Manage auditing and security log" and add user or group if SesecurityPrivilege is missing
Note: if add user or group is grayed out then it might be blocked by your group policy.
SQL 2012 or SQL 2008 installation failed with access denied or showing the error "setup account privileges" failed
Root cause :
the user account used for the sql installation is missing one of the below access
1. SeBackupPrivilege
2. SeDebugPrivilege
3. SeSecurityPrivilege
How to check if the user account have these access or not :
1. download accesschk.exe from http://technet.microsoft.com/en-us/sysinternals/bb664922.aspx
2. open the command prompt with elevated privilege
3. navigate to the accesschk.exe path in the command prompt
4. run the following command accesschk.exe domain\username *
5. The output will show all the privilege the user have and see if the above three privilege are listed
How to fix the issue :
If any of the above privilege is missing then follow the below steps to add those.
1. click start --->Run ----> gpedit.msc
2. expand local security policy ----> Local policies ----> User Rights Assignment
Double click "Backup Files and Directories Properties" and add user or group if SeBackupPrivilege is missing
Double click "Debug Programs" and add user or group if SeDebugPrivilege is missing
Double click " Manage auditing and security log" and add user or group if SesecurityPrivilege is missing
Note: if add user or group is grayed out then it might be blocked by your group policy.
No comments:
Post a Comment