Extremely Unusual Connection Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gderosa
    New Member
    • Nov 2006
    • 23

    Extremely Unusual Connection Problem

    I have an ASP.NET/VB.NET web application running on Server A (lets say Fred [http://fred/MyApplication/]) flawlessly. The web application is using impersonation to gain access to SQL Server. Server A is also known under another DNS (lets say Bob [http://bob/MyApplication]). If I access the same exact web application using Bob as the DNS instead of Fred (its on the same box, same location, etc., just different DNS) I get a periodic Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON' message. Now if I hit refresh then the page loads properly. This happens on every page that accesses the database.

    Any ideas why this is occuring? IIS is set to also advertise the DNS Bob in conjunction with the server name of Fred.

    Thank you very much!!!

    Here is the stack trace information:
    Code:
    [SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
       System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
       System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
       System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
       System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
       System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
       System.Data.SqlClient.SqlConnection.Open() +111
       System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
       System.Web.UI.WebControls.BaseDataList.GetData() +53
       System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) +474
       System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +56
       System.Web.UI.WebControls.BaseDataList.DataBind() +72
       System.Web.UI.WebControls.BaseDataList.EnsureDataBound() +55
       System.Web.UI.WebControls.BaseDataList.CreateChildControls() +63
       System.Web.UI.Control.EnsureChildControls() +87
       System.Web.UI.Control.PreRenderRecursiveInternal() +41
       System.Web.UI.Control.PreRenderRecursiveInternal() +161
       System.Web.UI.Control.PreRenderRecursiveInternal() +161
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
Working...