Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

[Dave]

I've been given the task at work to create a page for the internet.
Great, I've never done that before! So I start building. Looks
good...flows good...works great internally on the domain, so I put it
out for testing. Our production envirnment for this page is totally
independent of our company domain. All User Accounts will stay in an
MDF that resides with the Web Page.

Since I'm dealing with SQL Express now, I'm not sure what's happening
with the NT Authority\Network Services when someone tries to log in.
What Authorization and do I need to grant to NT Authority\Network
Service, and where do I grant it, for an ASPNetDB.MDF that resides in
the App_Data folder of an ASP.NET Web so that Membership.ValidateUser
doesn't fail? NT Authority\Network Service in SQL Express already
has SysAdmin rights.


I would greatly appreciate it if someone can help me with this so I
can meet the expectations of my supervisors, as well as further my
SQL (Express) knowledge.


Thank you

 

[Juan T. Llibre]

re:
!> What Authorization and do I need to grant to NT Authority\Network
!> Service, and where do I grant it, for an ASPNetDB.MDF that resides in
!> the App_Data folder of an ASP.NET Web

Give Authority\Network Service "Full Control" over the App_Data directory
by right-clicking the directory in Windows Explorer, selecting the Security tab,
and adding the account to the list of accounts which are allowed to access the
directory and the files in it.

 

[Guest]

Dave,
this page:
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
will explain a lot about SQLEXPRESS User Instances and why this arrangment
is often not suitable for a deployed solution.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com