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

it is a change in the way that ASP.NET works, add NETWORK SERVICE as a SQL login and assign it the same database access as the ASPNET user.

DavidM

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

This helped me:

Supporting integrated authentication with SQL Server
http://www.asp.net/faq/AspNetAndIIS6.aspx#4

sorry for not getting back to you - busy busy busy - but glad to see you got it working

DavidM

I tried adding this but it can't find the domain NT AUTHORITY. How did you add this user to your computer?

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

kspaenje's solution helped me.I changed the defaultAppPool identity to Local System. It worked.

Yes, Changing the Predefined account name from "Network Service"  to "Local System" under the Identity TAB

works.