I am trying to attach an aspnetdb.mdf file that is located on my desktop - which is part of a site I am working on. The directory for the site is saved on my desktop (that which I am working on in VS). When I go into Management Studio and then right-click on Databases to attach my aspnetdb.mdf file, it gives me the directory, but when I click on documents & setting/robert searing nothing expands below my username--thus I cannot see my desktop. When I try typing in the path to the file, it provides an error that it doesn't exist or no permission.

I have tried right-clicking on both the desktop folder that the site resides in and the app_data folder and have added web sharing....I'm sure there is something I am not aware of....

I am just trying to attach it so I can add several tables.

Thoughts?


Thanks so much!
Rob

The problem is likely due to permissions. "Your" desktop is just that, Yours. Your user is the only one with files access rights to the desktop. SQL server is running under a different security identity so it has no rights to access your desktop. The easiest fix is to move the MDF file to a common location outside of any user profile. Then you shouldn't have a problem.

-Peter