Failed: System.Data.SqlClient.SqlException: Login failed for user
'(null)'Reason: Not associated with a trusted SQL Server connection. at
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean
enlistOK) at
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance) at
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) at
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) at
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(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.