I am trying to set up my intranet to use some aspx pages. I am able to view the aspx pages from any browser on the intranet but when I try to access any dynamic data it errors out with:
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'.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnectionBase owningConnection) +90
I have set the authentication to sql and windows(mixed mode)
I added the IUSR account that the IIS server is using to access the webpage to the database users.
Windows 2003 server, intranet IIS and sql are running on the same server, ASP.NET 2.0..