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

Posted on 2007-08-06
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
    LVL 28

    Expert Comment


    Author Comment

    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

    Anyone have any other idea's? Now giving away 500 points.
    LVL 28

    Expert Comment

    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

    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

    Is this your database name?
    WizardWaste Woodys Haulage

    try to put them in square brackets.

    Expert Comment

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now