none
SQL server error password mismatch sometimes

    Question

  • 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

Answers

  • 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"
    http://support.microsoft.com/kb/925744

    Allen Li
    TechNet Community Support

    Monday, July 15, 2013 3:47 PM
    Moderator

All replies

  • Which driver do you use to connect? Check the driver version on win7 x64.
    Friday, July 12, 2013 8:59 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"
    http://support.microsoft.com/kb/925744

    Allen Li
    TechNet Community Support

    Monday, July 15, 2013 3:47 PM
    Moderator
  • If that's it, it is probably included in the katest service pack, I think SP4
    Monday, July 15, 2013 5:51 PM