SQL server error password mismatch sometimes


  • We have an application that connects to a MSSQL 2005 database using a generic login.  On 64bit Windows 7 machines users get a series of 'can't connect to database' errors after a period of inactivity in the software, usually around 15 minutes or so.  If they cancel the program and log back in it always connects and works fine (unless they are inactive for awhile again).  On the server we are seeing the "Error: 18456, Severity: 14, State 8" error in the logs which indicates a password mismatch but as I noted above, if the user cancels the program and logs back in, using the same credentials, it connects just fine.  This does not happen on WinXP or 32bit Win7 machines.  Any help would be greatly appreciated.

    Friday, July 12, 2013 8:36 PM


  • Hi Vedran,

    We can refer to the steps on the following link to troubleshoot the issue.

    FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"

    Allen Li
    TechNet Community Support

    Monday, July 15, 2013 3:47 PM

All replies