By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,866 Members | 1,704 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,866 IT Pros & Developers. It's quick & easy.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

P: n/a
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

Sep 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Dave" <Da**********@Jacobs.comwrote in message news:11**********************@k79g2000hse.googlegr oups.com...
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

Sep 22 '07 #2

P: n/a
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

"Dave" wrote:
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

Sep 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.