PROBLEM: after creating a brand new DNN Application framework site, and connecting to the database using SQL Server Management Studio, the application can no longer connect to the database: "Cannot open user default database. Login failed. Login failed for user '[machinename]\ASPNET'."
I have been able to reproduce this problem with a completely "virgin" site using Shaun's recipe for getting started with DNN development - here's what I've done:
1. Install DNN 4.5.5 Starter Kit
2. Open visual Web Developer & create a new DNN Application framework
3. Compile, open site in browser, create default site, etc.
(so now I have a completely "green" DNN 4.5.5. install working just fine)
4. Open SQL Server Management Studio & connect to the SQLEXPRESS instance on my machine
5. Attach the database.mdf in the APP_DATA directory
6. Go to browser & refresh home page of the brand new working DNN site
7. Site now reports "Cannot open user default database. Login failed. Login failed for user '[machinename]\ASPNET'."
8. Exit SQL Server Management Studio & Visual Web Developer (to ensure they aren't holding db open)
9. Restart IIS
10. Restart SQLEXPRESS service
No good. Nothing I do makes the site come back.
Please advise.