SQL Server Database Role Membership

Oct 8, 2007 at 12:02 AM
I am trying to tring to setup Blogengine SQL 2005/W2K3. After setting up the web.config and sql.config, I got the error that Login failed with NETWORK Service. So I added the NETWORK Service to the database user. Next I received the error that SELECT permission denied. Using the database role memership I assigned dbreader and dbwriter. It still complained with I tried to post something, so I decided to give it dbowner permssion (which is realy bad). Can someone tell me what are the neccessary role memership required ? I am suing the following connection string.
Data Source=(local);Initial Catalog=DB;Integrated Security=True

Interestingly, on my dev machine (Vista II7/SQLExpress), it worked without having to do add NETWORK SERVICE account to database. Looking at the database, that account is not even there. I verified that w3wp.exe on vista is running under NETWORK SERVICE. I am not sure why the application works flawlessly and doesn't compain about database.

Can someone help me understand this?