Access is denied restoring db bak

Aug 7, 2008 at 8: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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Aug 7, 2008 at 10:12 PM
I get the exact same error message - I hope the answer comes soon
Aug 8, 2008 at 1:59 PM
Check this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169145&SiteID=1

apparently the sql server express service Log On as needs to be changed from Network Service to Local System
Aug 8, 2008 at 2: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"/>