Hello,

we found a problem during the tests of our web application that use the Intersoft components.
We think that the problem is not due to the Intersoft components, but may be someone has just seen a similar problem and can give us a hint, to resolve it.

Our web application is deployed on IIS7 and we have experienced that the application works correctly if the IIS and SQL Server 2008, to which we connect, are on the same machine.
Unfortunately we have experienced that if IIS7 and SQL Server 2008 are on two different machines, we find a problem of authentication and we get the following error launching the web application.

When you have the IIS on which the web application runs and SQL Server on two different machines, have you ever experienced a similar problem ?

Thanks a lot for your help and suggestions.

Server Error in '/ISV/Speedy/SpeedyPlusOrderGridPr00016' Application.
________________________________________
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Source Error:

Line 13742: if (((command.Connection.State & global::System.Data.ConnectionState.Open)
Line 13743: != global::System.Data.ConnectionState.Open)) {
Line 13744: command.Connection.Open();
Line 13745: }
Line 13746: object returnValue;

Source File: C:\Fabio\MainTrunk\SpeedyCrm\OrderlineGrid\DataSet1.Designer.cs Line: 13744

Stack Trace:

[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
Wuerth.Phoenix.Speedy.OrderlineGrid.DataSet1TableAdapters.APRCollectionTableAdapter.modifiableAPRCollectionCount(Nullable`1 accountId) in C:\Fabio\MainTrunk\SpeedyCrm\OrderlineGrid\DataSet1.Designer.cs:13744
Wuerth.Phoenix.Speedy.OrderlineGrid.OrderPositionsGrid.enablePageOnOrder() in C:\Fabio\MainTrunk\SpeedyCrm\OrderlineGrid\OrderPositionsGrid.aspx.cs:615
Wuerth.Phoenix.Speedy.OrderlineGrid.OrderPositionsGrid.Page_Load(Object sender, EventArgs e) in C:\Fabio\MainTrunk\SpeedyCrm\OrderlineGrid\OrderPositionsGrid.aspx.cs:125
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053