I have two websites on a windows 2008 web server web edition server.
They both use the exact same connection string in the web config:
<add name="TUConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=TU;Integrated Security=True" providerName="System.Data.SqlClient" />
They both are setup in IIS7 with the exact same settings. They both have frontpage extensions installed.
They both have the same Authentication, Anonymous user with the same password.
The MS SQL Server 2008 database has the same user setup with permissions.
However, in one website I can hit the database just fine. But the second website gives me this error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I cannot for the life of me figure out why one website can connect and the other cannot. Again, the anonymous authentication specific user is exactly the same. I have typed it in numerous times and retyped the password numerous times for both sites to make sure they are the same.
What am I missing?