Home Forums SQL Server 2012 SQL 2012 - General Restore database fails with '5 access is denied' windows 2008 r2 RE: Restore database fails with '5 access is denied' windows 2008 r2

  • gchappell (10/2/2012)


    cphite thank you for your reply,

    The service is running, but how do you tell if it has access to a folder?

    Look for the column called "Log On As" for the service. That is the account the service is running as.

    Next, go to the folder (in your case I:\MSSQL-DATA\MSSQL.1\) and right-click on it.

    Select Properties.

    Go to the Security tab.

    If the "Log On As" user from your service is a user account, make sure that user account has Full Control for the folder.

    If the "Log On As" user from your service is "Network Service" or "Local System" those account should already have access, but go ahead and add them and give them Full Control.

    BTW, are you sure that your I:\ drive is local and not a network drive?