Post reply

Login issue for one Instance on failover node

  • April 12, 2019 at 4:43 pm

    #3163113

    Hello,

    We have two fail-over node 01 and 02 and three instances (Ins1, Ins2 and Ins3) on these two nodes.

    I can able to login to all three instances from node 02 using my windows authentication but i can't login to only Ins3 on node 01.

    I am receiving error as below while trying to connect to Ins3 on node 01.  After that error i can't login to node 01 and my reference account get locked as well. Any help would be greatly appreciated.

    • This topic was modified 5 years, 7 months ago by  EasyBoy.

  • April 12, 2019 at 4:45 pm

    #3163130

     

     

     

    • This reply was modified 5 years, 7 months ago by  EasyBoy.

  • April 12, 2019 at 5:38 pm

    #3165227

    The error didn't come across if that was an attachment - could you type out the exact error message and error number?

     

    Sue

  • April 12, 2019 at 5:42 pm

    #3165429

    Cannot connect to the server.

    ------------------------------

    ADDITIONAL INFORMATION:

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

  • April 12, 2019 at 6:08 pm

    #3165971

    Thanks...they show up now. You can find more information for the error in the SQL Server error log or clicking on the Technical Details on the bottom left of the error message box, the third icon. You want to get the state code for login failures.

    Sue

  • April 12, 2019 at 8:23 pm

    #3172512

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.11.12.13]

    Error: 18452, Severity: 14, State: 1.

    SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed 10.11.12.13

  • April 14, 2019 at 6:53 pm

    #3338803

    EasyBoy wrote:

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.11.12.13] Error: 18452, Severity: 14, State: 1. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed 10.11.12.13

     

    For SSPI handshake failed errors, you want to check the security event log on the server as it will provide more information on the specifics for the failure. Also make sure your password hasn't expired. The blog has more information and checking the security event log related to this error:

    https://blogs.msdn.microsoft.com/docast/2016/02/11/common-sspi-handshake-failed-errors-and-troubleshooting/

    Sue

Viewing 7 posts - 1 through 6 (of 6 total)

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