SQL Authentication problem

Failed: System.Data.SqlClient.SqlException: Login failed for user
'(null)'Reason: Not associated with a trusted SQL Server connection. at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance) at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open()

Environment:

Single Windows 2003 AD domain
SQL Server 2000 SP4 on w2k03 server

web service running on a W2k03 SP1 Server
ASP.NET 2.0.50727

web.config has:

<authentication mode="Windows"/>
<identity impersonate="true"/>

IIS set to Integrated Windows Integrated Authentication (no anonymous)



I can get the web service to work when I'm on the server and point to
localhost

When i'm remote (again, inside the domain with a domain login
authorized to the SQL resources) I get the error.

.

Relevant Pages

  • Re: Cant open Northwind
    ... An unhandled exception occurred during the execution of the ... > owningObject, SqlConnectionString connectionOptions, String newPassword, ... > options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
    ... exception, Boolean breakConnection) ... owningObject, SqlConnectionString connectionOptions, String ... String newPassword, SqlConnection owningObject, Boolean ... owningConnection, DbConnectionPool pool, DbConnectionOptions options) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: .NET Apps stop working after running asp_regiis -i
    ... the remote IIS 6.0 server. ... The aspnet user account kept getting locked out on the remote box, ... DbConnection owningObject) ... owningConnection, DbConnectionPool pool, DbConnectionOptions options) ...
    (microsoft.public.dotnet.framework.aspnet)
  • .NET Apps stop working after running asp_regiis -i
    ... the remote IIS 6.0 server. ... The aspnet user account kept getting locked out on the remote box, ... DbConnection owningObject) ... owningConnection, DbConnectionPool pool, DbConnectionOptions options) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upgrading SPS 2003 to MOSS 2007 problem
    ... We had an SPS 2003 server that we moved to new ... I'm logged in and running the install as our sharepointadmin domain ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ... owningObject, SqlConnectionString connectionOptions, String ...
    (microsoft.public.sharepoint.windowsservices)