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?