Two websites, same connection, same web.config, error

Posted on 2008-11-10
Last Modified: 2013-11-26
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?

Question by:BobCSD
    LVL 32

    Expert Comment

    by:Daniel Wilson
    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.
    LVL 1

    Author Comment

    Where is Kerberos set up? Becuase I am not doing anything with it myself.
    LVL 32

    Assisted Solution

    by:Daniel Wilson
    There's a lot to read on it ... and I haven't done it myself, so I'll refer you to some who have:
    LVL 1

    Accepted Solution

    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.
    LVL 1

    Author Comment

    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.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now