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

  • October 2, 2012 at 9:28 am

    #1544450

    gchappell (10/2/2012)

    We have just installed SQL Server 2012 Standard edition on a Windows Server 2008 r2 Enterprise edition. While attempting to restore a database from a SQL Server 2005 backup we get the following error

    System.Data.SqlClient Sql Error:: The operating System returned the error '5(Access is denied)' while attempting to 'restore container:: validate target for creation' on I:\MSSQL-DATA\MSSQL.1\mydatabase.mdf

    Have not run into this before anyone have insight?

    George

    Make sure that the account SQL Server (the service) is running as has access to that folder.