SQL Server Problem. "Error: 18456, Severity: 14, State 5".

Posted on 2007-08-06
Medium Priority
Last Modified: 2008-09-19
Hi all.

I am having a problem with SQL Server 2005. I had noticed that the C drive on my server was starting to run low on space. After checking to see what was the cause of this, I found that the SQL error logs were the cause of the problem. I then logged into SQL Server Management Studio and checked out what could be causing this problem.

I have found that in the SQL Agent, Current log there are many thousands of failed logins that are happening at a rate of 2 a second. There are many different usernames its reporting as having to failed to log in. "Error: 18456, Severity: 14, State 5". I have checked with the users who are using the database and they have not reported any faults. Everything appears to be working for them correctly.

Any idea's on how to rectify this problem would be appreciated.
Question by:Wizard_IT
  • 3
  • 3
LVL 28

Expert Comment

ID: 19638114

Author Comment

ID: 19638197
Thanks for your reply. I have noticed in that link you sent me that the user who had the same problem we are experiencing done the following to rectify the problem...

A couple of days back i have reported a problem about Error: 18456, Severity: 14, State: 5. and in SQl logs i used to get Login failed for user 'administrator'
The solution was to disable SQl Fibers
The system is running fine now.

Do you know where these SQL fibers are located? The one we found was located in Server Properties, Processors, Use Windows Fibers (lightweight pooling). By default it is off on our Server. Changing this setting did not make any difference.

Author Comment

ID: 19682432
Anyone have any other idea's? Now giving away 500 points.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 28

Expert Comment

ID: 19682530
ok what is the connection string you are using for your application
may be it is

Server=XXX;Database=XXX;User ID=domain\user;Password=password;Network Library=XXX;Trusted_Connection=False;<------

and so

by setting trusted_connection=false you are implying you wish to use SQL Authentication not Windows. Thus your user must be created on the destination sql server and sql authentication must be enabled on the server itself.


Author Comment

ID: 19746071
Thanks for your reply.

The string we are using is as follows...

ODBC;DRIVER=SQL Server;SERVER=paul;DATABASE=WizardWaste Woodys Haulage;TABLE=dbo.Haulage Free Tip Lines

Its using mixed mode authentication.
LVL 28

Accepted Solution

imran_fast earned 2000 total points
ID: 19767254
Is this your database name?
WizardWaste Woodys Haulage

try to put them in square brackets.

Expert Comment

ID: 20779540
im having the same problem, log file is giving me the following logs:
2008-01-30 11:33:54.18 Logon       Error: 18456, Severity: 14, State: 5.
2008-01-30 11:33:54.18 Logon       Login failed for user 'swaqar'. [CLIENT: <local machine>]
2008-01-30 11:39:59.17 Logon       Error: 18456, Severity: 14, State: 5.
2008-01-30 11:39:59.17 Logon       Login failed for user 'swaqar'. [CLIENT: <local machine>]

im using the below connection string:
Dim objConn As New SqlConnection("Server=SVSWAQAR\SQLEXPRESS;User ID=FCC\swaqar;Password=Touchtell123;Database =master;)

i dont know where can i can my head towards in order to fix it. Please help me fix this issue and get your reward on the below link:

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question