Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > question about login at server level in sql server express

Thread Tools

question about login at server level in sql server express

Posts: n/a

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 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?


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
question about login at server level in sql server express Jean ASP .Net Security 0 08-28-2007 10:03 AM
SQL Server 2000 vs SQL Server Express Grey Alien ASP .Net 6 07-09-2007 09:40 AM
SQL Server 2005 + SQL Server Express farseer ASP .Net 3 08-08-2006 04:07 AM
c is a low-level language or neither low level nor high level language pabbu C Programming 8 11-07-2005 03:05 PM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM