I exported a 2008 DB to a different 2008 SQL server. When I tried to access that database with the client, this error is being generated. Any ideas? All servers and clients are in the same domain but different subnets. Thanks
Log Name: Application
Source: MSSQLSERVER
Date: 05/26/2015 02:16:18 pm
Event ID: 17806
Task Category: Logon
Level: Error
Keywords: Classic
User: N/A
Computer: SG-W28-ENGSQL.firm.ebglaw.com
Description:
SSPI handshake failed with error code 0x80090302, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: ].
Event Xml:
17806
2
4
0x80000000000000
172952
Application
SG-W28-ENGSQL.firm.ebglaw.com
80090302
14
AcceptSecurityContext failed. The Windows error code indicates the cause of failure.
[CLIENT: ,IP>]
8E450000140000000E000000530047002D005700320038002D0045004E004700530051004C00000000000000
Log Name: Application
Source: MSSQLSERVER
Date: 05/26/2015 02:16:13 pm
Event ID: 18452
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: N/A
Computer: SG-W28-ENGSQL.firm.ebglaw.com
Description:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.111.186.41]
Event Xml:
18452
0
4
0x90000000000000
172951
Application
SG-W28-ENGSQL.firm.ebglaw.com
[CLIENT: ]
144800000E0000000E000000530047002D005700320038002D0045004E004700530051004C000000070000006D00610073007400650072000000