Livin' the life...

Currently, I am in a state of disbelief as to how difficult it is to be able to create a fully functional website in VS'05 and then have that same website GIVE PAIN to work under IIS. (This is mostly with respect to ASPNETDB.MDF and SQL Server 2005 Express dbs in general - with Integrated Security = True.)

And I understand, I'm new-ish, so I may make silly mistakes but some of these podcast and videos online give NO HELP WHATSOEVER. They show how to do the development under VS'05 (which runs everything under your user account ie what DOES NOT HAPPEN when the site is deployed to IIS), yet they do not show how to deploy the web app and have it work!

Thus far I've been plagued by errors such as:

Cannot open user default database. Login failed. Login failed for user 'PC\ASPNET'.
(This is just as I try to login using the new login controls which are to interact with ASPNETDB.MDF)

An attempt to attach an auto-named database for file C:\...\DB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
(This is just as I try to Connect to my DB under SQL Express... For this one I found out I had to detach the db from Express FIRST.)

Also, online, there are tons of people facing this same problem and solutions have been suggested such as changing NTFS permissions on the DB folders and files to allow read/write/modify access to ASPNET user account... For me though, that doesn't seem to work with any stability at all (ie I could wake up this morning, it works, go have lunch, come back and it doesn't).

MS... what are you really about though? I mean, if there are "expected" changes people are suppose to make (eg. setting up NTFS permissions, SQL User accounts for ASPNET, NETWORK SERVICE Windows accounts), WHY NOT MAKE IT CLEAR? Stupse.

The login controls, Web site Admin tool etc were a step forward but, the deployment stage is LACKING (for lack of a better word). Or... am I suppose to keep the app in development mode and put it on the web site like that ie running under VS'05?

Bleh.