x

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

more ▼

asked Dec 10, 2010 at 04:47 AM in Default

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Dec 10, 2010 at 04:58 AM

avatar image

Grant Fritchey ♦♦
137k 20 42 81

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Dec 10, 2010 at 05:06 AM

avatar image

Leo
1.6k 55 59 62

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x408
x197
x102

asked: Dec 10, 2010 at 04:47 AM

Seen: 1582 times

Last Updated: Dec 10, 2010 at 06:24 AM

Copyright 2016 Redgate Software. Privacy Policy