469,338 Members | 8,114 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,338 developers. It's quick & easy.

question about login at server level in sql server express


I have a question about logins and sql server express and an ASP.NET
aplication. I put this question in sql server newsgroup, but without real
answer sofar.

I created a login 'Network service' at server level in Management Studio
I use windows authentification.
Then i defined an user for my database which is associated to login 'Network
service', because the application asp.net uses that account (IIS 6.0). This
user received db_read and db_write roles.

This works.

Now i experimented a little bit and i removed from the logins at server
level the login 'Network service'.
Result: the application still works.
Then i removed the Builtin\users login from the login list at server level.
Result: i get the error: "login failed for Network service".

I recreated then the login 'Network Service' at server level but not the
Builtin\users login.
Result: it works again.

My conclusion is: one of the two logins must be in the list: Network Service
or Builtin\users

Is this right?
Why do i get that error when both logins are removed and not only when
Network Service is removed?

Aug 28 '07 #1
0 1095

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by nedk | last post: by
3 posts views Thread by Alexander Higgins | last post: by
8 posts views Thread by =?Utf-8?B?U2hlcndvb2Q=?= | last post: by
4 posts views Thread by RN1 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.