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?

LVL 2
Starr DuskkASP.NET VB.NET DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel WilsonCommented:
Sounds to me like a Kerberos issue.  Kerberos is set up for the DNS name you're using to get to one site, but not the other.

Maybe I'm wrong ... but when I'd covered all the bases you describe, that was the one I missed.
0
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
Where is Kerberos set up? Becuase I am not doing anything with it myself.
 
0
Daniel WilsonCommented:
There's a lot to read on it ... and I haven't done it myself, so I'll refer you to some who have:
http://support.microsoft.com/kb/319723
http://support.microsoft.com/kb/326985
0
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
It wasn't kerberos. I had that on.
The problem was, I believe, the two sites weren't the same, I needed:
    <identity impersonate="true" />
in both.
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
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.
 
 
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.