Post reply

Error 18456 state 8

  • February 4, 2011 at 6:24 am

    #246223

    We have an access application that uses ODBC to connect to an sql server 2008 database via a VPN connection with the connection encrypted.

    Connection string looks like this :

    ODBC;DRIVER=SQL Server;SERVER=xxx;DATABASE=xxx;Trusted_Connection=No;Network=DBMSSOCN;Encrypt=Yes;UID=rt;Password=Fm6210

    Works perfectly most of the time but intermittently suddenly asks the user for a password. When tracking the error in debug the connection string always has the correct password.

    Sqlserver logs a password mismatch error 18456 state 8.

    Once the user enters the password the application works fine for a while before asking for the password again.

    Any assistance would be appreciated.

  • February 4, 2011 at 7:01 am

    #1282431

    A bit strange that it works then does not work.

    State 8 refers to a password mismatch, so I wonder if the there is something weird in the encryption if the connection is open for too long?? Not sure... I would try it without the encryption enabled and see if it continues to raises errors like this.

    BTW - Please tell me that you did post a REAL password on an open forum........

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply