I'm using Sql Server Express 2008 and I'm trying to attach a datbase .mdf file that is located in the app_data folder of a web application in my development environment.
When I try and attach the database, I get the following error message:
Unable to open the physical file "C:\My Documents\Visual Studio 2008\Projects\Security\Projects\Web App\Security\App_Data\Security.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)
I tried to add the ASPNET user to the directory, but the ASPNET user was not listed? How can I resolve this issue and get the database attached.