Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation

Generally you would get error on:

>> During installation

>> when try to start the sql services.

>> After installation when try to access instance.

You would get “ACCESS DENIED” error.

To resolve this issue, you have to provide access at Secpol.msc and regedit to service account your sql server is running with:

secpol.msc:

Go to Security Settings-> Local Policies ->User Rights Assignment.

your sql service account should be included in following:

RegEdit:

  • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\WinHttpAutoProxySvc -SQL Server Service should have FULL CONTROL on this key.

http://blogs.msdn.com/b/joaol/archive/2008/12/02/sql-server-2008-installation-aborts-due-an-access-denied.aspx

Restart the machine.

Most of the time it should work.

Will try to write more on securities later

Ref:

http://social.msdn.microsoft.com/Forums/eu/sqlsetupandupgrade/thread/994bb1a4-2929-4e0e-adc2-2960f9184f90

http://blogs.msdn.com/b/askjay/archive/2011/02/28/required-rights-for-sql-server-service-account.aspx

About these ads
This entry was posted in Error Log, Installation, Troubleshooting and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s