Access is denied restoring db bak

Aug 7, 2008 at 9:59 PM

I am not able to restore the database this is the error I am getting..

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'I462-5004973\CBCHAOS'.  (Microsoft.SqlServer.Express.Smo)

For help, click:


System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\dropthings.mdf'. (Microsoft.SqlServer.Express.Smo)

For help, click:



Aug 7, 2008 at 11:12 PM
I get the exact same error message - I hope the answer comes soon
Aug 8, 2008 at 2:59 PM
Check this thread:

apparently the sql server express service Log On as needs to be changed from Network Service to Local System
Aug 8, 2008 at 3:19 PM
You may also have to change the Web.Config sqlserver configuration line to use Integrated Security versus a specific user id:
        <add name="DashboardConnectionString" connectionString="Data Source=.\sqlexpress;Initial Catalog=dropthings;Integrated Security=True;" providerName="System.Data.SqlClient"/>