Post reply

alerts

  • April 9, 2010 at 5:24 am

    #223140

    SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.

    plz let me know y it comes alert

  • April 9, 2010 at 6:00 am

    #1148988

    usually someone has left a connection open to the sql server and their password has expired or their account has been disabled (or connection to the domain controller may have been lost)

    often common in developers who leave management studio connected to the server over the weekend and lock their workstation

    check the error message - it will tell you the client IP address that is connecting

    then run cmd prompt and perform the following

    ping -a 92.167.66.23 (replace this with the real ip address of the client)

    this might resolve it to a workstation name (if it local network)

    then you can perform

    NET VIEW in the command prompt to see any notes that might be about this machine

    MVDBA

  • April 9, 2010 at 6:21 am

    #1149012

    Thanks friend the solution is really good.very thankfull to you.

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

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