Error: "Invalid Login Details for : *********" - Cannot generate SSPI Context
Windows Authentication fails. SSPI uses Kerberos to delegate over TCP/IP and Kerberos cannot complete the operations to successfully delegate the User Security token to the destination computer that is running SQL.
Note: This is not a LiteSpeed error, it is a Microsoft Active Directory error. For additional troubleshooting or support, please contact Microsoft Support.
1. Run the Microsoft utility: SETSPN -A
2. Run SQL CLNCONFG utility and uncheck the box to forced encryption if required.
3. Restart the SQL Service.
For more information:
Microsoft Article ID: 811889 - "How to troubleshoot the "Cannot generate SSPI context" error message":
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Microsoft Article ID: 319723 - "How to use Kerberos authentication in SQL Server":
http://support.microsoft.com/default.aspx?scid=kb;en-us;319723
All versions of SQL Server
All versions of LiteSpeed
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center