We help IT Professionals succeed at work.

SQL Server 2008 SP2 failing becasue of issue "Setup account privileges" which says that I do not have the necessary Windows permissions.

Medium Priority
4,623 Views
Last Modified: 2012-08-14
When I try and install SP2 it never gets past the initial checks as the "Setup account privileges" check fails. Its says that

"The account that is running SQL Server Setup does not have one or both of the following rights: the right to back up files and directories, and the right to manage auditing and the security log."

I am logged on as a local administrator and therefore I cannot understand why I do not have the necessary permissions.

Regards,

  Conor
Comment
Watch Question

Commented:
Hi,

Try this, right click on the setup.exe in SP2 and ran it as an administrator.

Author

Commented:
No I have tried that and it still fails. Thanks for the suggestion.
CERTIFIED EXPERT

Commented:
Have you run the prerequisite checker? Is this where you find the issue?

Guide to install:

http://msdn.microsoft.com/en-us/library/ms143219.aspx

Also see article regarding required rights:

http://support.microsoft.com/kb/2000257


Author

Commented:
The issue arises when I run the SP2 executable. It is the first screen that comes up, the "welcome" screen, where it checks all the prerequisites.
CERTIFIED EXPERT
Commented:
Are you logging into the machine with DOMAIN\USERNAME

Ensuring this is domain admin with local rights?

Really sounds like a rights/profile issue as the install is fairly straight forward

Author

Commented:
Yes I am logging in with a domain user which I have put in as a local administrator.
Even when I log in as a domain administrator I get the issue. I think its a Windows issue but it just surprising that it allows me to install the base software but not the SP on top of it.
CERTIFIED EXPERT

Commented:
Yes that is very odd. Maybe try and download the Service Pack again in case something is wrong with that install? Corrupted or soemthing?

Otherwise run Windows updates and reboot server then log back in as Admin and try again.

Commented:
Why not log as local administrator instead of domain user?

Author

Commented:
I tried that. I created a local admin and it still threw up the same error.

Author

Commented:
OK I think the problem was due to logging in under the actual domain that the server is on. If you log on under a non-domain user with local admin privs or under a domain user which has a trusted relationship with the domain it does not seem to be enough.

Author

Commented:
.