x

Login failed for user ''. The user is not associated with a trusted SQL Server connection

We are observing the below error in SQL error log file.

2014-08-10 06:20:04.80 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: X.X.X.X] 2014-08-10 06:20:05.79 Logon Error: 18452, Severity: 14, State: 1.

four application servers are doing the transaction with this DB server using same SQL login.

We are getting successfull transactions as well in all application servers.

Please help to understand why this error is coming for some of the tansactions only.

more ▼

asked Sep 23, 2014 at 10:15 AM in Default

avatar image

Bincy
71 2 6 9

The error "The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies." is also showing in SQL error log prior to Login failer for user ''- error-18452.

Is there any relation between these two errors. If so what needs to do to resolve the kerberos problem.Please help..

Sep 27, 2014 at 05:21 AM Bincy

This site runs off of votes. Please indicate all helpful answers below by clicking on the thumbs up next to them. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.

Sep 27, 2014 at 10:38 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Have you run through the steps in this article? http://support.microsoft.com/kb/555332

If you have, then is there more information you can share with us? Other errors in the log just before or just after the one you posted would be useful.

more ▼

answered Sep 23, 2014 at 03:28 PM

avatar image

CirqueDeSQLeil
5.5k 11 13 20

We are not getting any other errors in the log apart from 18452.

The error is not showing the username with in the single quotes.(Login failed for user '').

Is this means the application is trying to authenticate with out passing any user name to SQL?

If so ,why its not passing the username to authenticate for few transactions only,as the SQL username is already configured in application and successful transactions also happening.

Sep 24, 2014 at 07:21 AM Bincy

Have you confirmed that the transactions that are working are coming from the same user? This error usually means one of the three things discussed in the article provided. The most common being that SQL Server is not configured for SQL Auth and your application is trying to pass a SQL User to authenticate instead of a Windows account.

Sep 24, 2014 at 01:32 PM CirqueDeSQLeil
(comments are locked)
10|1200 characters needed characters left

Hello we need more information to help you

  • Has anything in the environment changed?

  • Do the failed connections have anything in common? e.g. Are they all from teh same service or application? Do they all come from one server?

  • What type of application is trying to access the database?

  • What authentication mode is the Database server in?

  • Is it a single server or a cluster?

more ▼

answered Sep 24, 2014 at 07:36 AM

avatar image

alex.crichton
1

This is not a new error we are observing in the logs like after application changes. Not done any changes recently. We are getting this error from different applications and from different application servers. We have four application servers communicating with this db server.all four application servers IP address is showing in the error log. IVR (VXML) application which is running in tomcat6.0 is trying to access the DB server. DB server is having mixed mode authentication(SQL and Windows) Its a single DB server . Not in cluster.

Sep 24, 2014 at 09:45 AM Bincy

Can you run sql server profiler on the instance see what requests are failing and if they have anything in common

Sep 25, 2014 at 08:03 AM alex.crichton
(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:

x1154
x215
x108

asked: Sep 23, 2014 at 10:15 AM

Seen: 5458 times

Last Updated: Sep 27, 2014 at 10:38 AM

Copyright 2017 Redgate Software. Privacy Policy