I have a web application with a SQLExpress 2008R2 database in the AppData folder. I wanted to make an update to the database manually so in IIS I took the site offline.
On the server I opened SQL Management Studio (as Administrator) and attached the database file and made my edits.
I then detached the database dropping all connections and closed out the management studio.
When I restarted the web application it can no longer connect to the database?
I found mention of this in this article (item3) but no reference to the workaround for this issue: http://blogs.msdn.com/b/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx
How can I work around this and get the app to use the database again?