When I try to log into my website over the internet, I get the error "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'." I did some research and found that I need to make sure that Network Service was an allowed user of SQL Server. So I went into Enterprise Manager, but Network Service wasn't a listed user that I was able to add. ASPNET was a choice, so I added that, but it still didn't work. After further research, I found that changing identity settings in the APP Pool in IIS might work. But still to no avail. Is there something I'm missing? Any help would be appreciated. FYI, I'm running Server 2003 IIS6.0, SQL Server 2000.
...
Go to the complete details ...