Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 27th, 2007, 04:40 PM
Friend of Wrox
Join Date: Apr 2006
Location: , , .
Posts: 160
Thanks: 0
Thanked 0 Times in 0 Posts
Default question about login at server level


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?


Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Two Level Dynamic DropDown Question workib ASP.NET 3.5 Basics 6 May 14th, 2008 09:18 PM
Two Level Dynamic DropDown List Error Question workib BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 1 May 3rd, 2008 02:37 AM
.level and .data files question H2O BOOK: Professional XNA Game Programming: For Xbox 360 and Windows ISBN: 978-0-470-12677-6 0 September 17th, 2007 06:03 AM
access control at server level qwjunk Apache Tomcat 2 July 13th, 2007 03:31 PM
Multi-level output w/ server side controls? glandgraf@gocfi.com .NET Framework 2.0 0 February 2nd, 2005 03:20 PM

All times are GMT -4. The time now is 09:02 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.