asked
sql server 2008
hi Team i can see the error in high number in my xp_readerrorlog **Logon,Unknown,Error: 17806 Severity: 20 State: 2. Logon,Unknown,Login failed for user ”. The user is not associated with a trusted SQL Server connection. [CLIENT: IPAddress] Logon,Unknown,Error: 18452 Severity: 14 State: 1. Logon,Unknown,SSPI handshake failed with error code 0×80090311 while establishing a connection with integrated security; the connection has been closed. *** what might b happening
A domain login is attempting to connect to a database server that it doesn't have access to. You need to examine the app to see what it's doing, how it's connecting, connection string, the works, and the database server to ensure that the login does exist and does have the correct access.
This can happen when your application cannot contact Domain Controller (DC) server, for instance if client is in one domain and sql server is in another domain and also the trusted link between those domains has been broken or does not exist.
