SQL 2008 R2 Install Permissions

21.08.17 06:59 PM Comment(s) By Jordan

SQL 2008 R2 is a little tricky to install if you don’t have the right permissions.  If the account you are using does not have the correct permissions you will find yourself getting loads of strange errors such as below during the installation.

not all privileges or groups referenced are assigned to the caller

The process does not possess the ‘SeSecurityPrivilege’ privilege which is required for this operation

The error will prompt you to retry or cancel.  If you cancel your SQL installation will fail and if you retry you will be prompted with the error again.

The way to resolve this issue is to grant the account you are using the correct privileges.

Local Administrator on the box you are installing SQL

Goto > Local Security Policy > User Rights Management
Back up files and directories
Debug Programs
Manage auditing and Security log
Restore files and directories
Take ownership of files or other objects

Add your installation user account to the above User Rights Management

Once this has taken affect you should be able to install SQL without any issues.

Jordan

Share -