Post reply

Cannot generate SSPI context. (.Net SqlClient Data Provider)

  • April 11, 2013 at 6:54 am

    #394566

    Hi..

    Suggest me to resolve this issue please…

    For some reason SQL service account password changed and from that point I am unable to connect to that server from outside [Oust side means from my local SSMS].

    But I can access that through RDP.

    Just they modify the password for existing domain account. [Conceptually it won’t affect anything because they changed password for that account only not services account name].

    error message : Cannot generate SSPI context. (.Net SqlClient Data Provider)

    Please let me know if you need any other details to resolve this/ to answer this.

    Thanks in Advance,

    --Krishna

  • April 11, 2013 at 9:01 am

    #1605629

    You are sure nothing else changed with the service account? Check the SQL Server error log for messages about the SPN being registered where it wasn't before the change, or vice-versa.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 11, 2013 at 9:42 am

    #1605665

    Thank you...

    Issue been resolved by resetting SPN [Service principle Name]....

    --Krishna

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

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