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

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(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

Leo gravatar image

1.6k 54 56 58

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Dec 10, 2010 at 04:47 AM

Seen: 1374 times

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