Hello mates, I get an error when I view http://localhost/StoreVBVS/Default.aspx. I did have one error during the initial setup which was, "[Fail] Could not add ASPNET user to SQL Server. Windows NT user or group 'ASPNET' not found. Check the name again." Do
I manually create the user and do I create it in SQL Enterprise Manager or do I create it in Active Directory Users and Computers? I don't know but this may/probably has to to with the error I get when I open http://localhost/StoreVBVS/Default.aspx. The error
is as follows and before we get to it I want to thank anyone who is kind enough to respond to my plea in advance, you are a great person =) And now to the error: Server Error in '/StoreVBVS' Application. --------------------------------------------------------------------------------
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception
Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Source Error: Line 63: Line 64: ' Execute the command Line 65: myConnection.Open() Line 66: Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 67: Source File: C:\StoreVBVS\StoreVBVS\Components\ProductsDB.vb Line: 65 Stack Trace: [SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 IBuySpy.IBuySpy.ProductsDB.GetProductCategories() in C:\StoreVBVS\StoreVBVS\Components\ProductsDB.vb:65 IBuySpy.C_Menu.Page_Load(Object sender, EventArgs e) in C:\StoreVBVS\StoreVBVS\_Menu.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Page.ProcessRequestMain() +731
David, I want to first thank you for your time and responce. I have just a few things I want to check with you. About the ASPNET user, should it be created in the Security part of SQL Enterprise Manager or should it be a windows account? I created NETWORK SERVICE
under the Security part of Enterprise Manager and gave it owner access to every database. Should I use SQL Server Authentication for both ASPNET and NETWORK SERVICE accounts and should they have blank passwords? Thank you again, GregF
Greg1, Did you get your connection working? I have the same problem. Did you create the ASPNET acct and NETWORK SERVICE acct.? How did you create them? Thank you, Jaime
I have the same problem, in my computer, there is an ASPNET user (that the .net framework installed) but there is no NT AUTHORITY\NETWORK SERVICE user. I wonder how is that user created. Thanks Luis
I got it working! Thank you DavidM! I followed DavidM's advice and in SQL Enterprise Manager I added a user 'NT AUTHORITY\NETWORK SERVICE" and gave it all the access I could. And it worked. It wont work unless you have "NT AUTHORITY\" before "NETWORK SERVICE".
Good Luck, Greg1
Just type it in with the backslash in front of the user ID as in: "'NT AUTHORITY\NETWORK SERVICE" And you DON'T need to give it ALL rights EVERYWHERE! (You'll open up the same security hole that existed before, by an outsider assuming you HAVE such a user named
that and it's "all powerful" in the SQL server!) Just give it ownership of any databases your WEB Server apps create/use. Mike
I was getting the same problem. I resolved it by adding User IIS_WPG and granting it all rights and permissions to the Community Starter Kit Database. I got there by using the SQL Server Enterprise Manager and going to the Security/logins for the server. You
can then do a new Login and use the ... on the name to list all of the users and roles available on the server. I then did a trial and error by adding a few accounts that might be associated with process and finally by setting the IIS_WPG rights, it began
to get by this error.
The solution is actually quite simple. Go to the Internet Information Server Manager (IIS), open the DefaultAppPool Properties and choose Local System as the Predefined Security Account for the servers web apps. greets
None
0 Points
3 Posts
Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 02, 2003 02:12 AM|Greg1|LINK
None
0 Points
364 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 02, 2003 09:36 AM|DavidGMiles|LINK
Lead Developer [vb & c#] - MCAD
None
0 Points
3 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 02, 2003 03:54 PM|Greg1|LINK
None
0 Points
2 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 05, 2003 10:04 AM|jaimea|LINK
None
0 Points
3 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 06, 2003 01:49 PM|luisvelasco|LINK
None
0 Points
3 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 07, 2003 04:20 PM|Greg1|LINK
None
0 Points
1 Post
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 07, 2003 04:38 PM|MazQuest|LINK
None
0 Points
364 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 07, 2003 06:11 PM|DavidGMiles|LINK
Lead Developer [vb & c#] - MCAD
None
0 Points
12 Posts
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 08, 2003 05:31 PM|davidvairin2|LINK
None
0 Points
1 Post
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 14, 2003 05:51 PM|MikeFaulkner|LINK
None
0 Points
1 Post
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
May 17, 2003 06:23 PM|appschannel|LINK
None
0 Points
1 Post
Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
Oct 10, 2003 01:31 PM|kspaenje|LINK