App_Data and SQL Server 2008

.NET
1

In the past I’ve used the App_Data directory for storing text files for e-mail templates and the occasional Access database.

In SQL 2008, I’ve always put the .mdf in the SQL DATA directory. This works great but I thought it would be nice to have the entire application stored in one place.

So I detached the database in the SQL Server Management Management Studio, moved the files to the applications App_Data folder, and went to reattach it. But it won’t let me browse to C:\inetpub\vhosts\

It just doesn’t display any of its contents. I guess it’s a permissions issue but I don’t know what permissions to change. I log on to the database server using Windows authentication, and I’m logged into Windows as an Administrator.

Should I not be using the App_Data directory in this way or something?

2

It’s been a while since I’ve seen this, but if I’m not mistaken, the mdf’s internal name still reflects the old path and I don’t recall now how to resolve it, but that should be enough info to search on google or msdn.

[EDIT] Instructions on moving a database.