Starr Duskk
asked on
Two websites, same connection, same web.config, error
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?
They both use the exact same connection string in the web config:
<add name="TUConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial
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?
ASKER
Where is Kerberos set up? Becuase I am not doing anything with it myself.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Kerberos in IIS7 is in:
select web site.
go to features panel
select authentication icon
enable windows authentication
select advanced settings
enable kernal mode authentication checkbox has to do with kerberos. read info below that.
select web site.
go to features panel
select authentication icon
enable windows authentication
select advanced settings
enable kernal mode authentication checkbox has to do with kerberos. read info below that.
Maybe I'm wrong ... but when I'd covered all the bases you describe, that was the one I missed.