Post reply

Error: 17806, Severity: 20, State: 2.

  • October 1, 2010 at 5:11 am

    #97593

    Hi

    I got this error .Please help me to solve this.

    Error: 17806, Severity: 20, State: 2.

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

    After this i got again another error...

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

    Login failed for user ''. The user is not associated with a trusted SQL Server connection.

    we are using sql server 2005,standard eddition.

    Thanks in Advance....

  • October 3, 2010 at 10:53 pm

    #1230823

    The first error code indicates that SQL Server is unable to authenticate with the Active Directory. Check if the SPN is created properly. Refer this

    Are you able to connect using SQL Server authentication?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • June 3, 2013 at 4:29 am

    #1620458

    THanks adiga.

    who will do "register an SPN " activity? Is it windows team, right?

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

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