Cannot generate SSPI context error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cannot generate SSPI context error

Hi, We are running an Active/Active SQL cluster and we are currently getting an error on the second instance of SQL in our clustered environment. The error is being generated by a DTS package that is trying to generate a file from the database using windows authentication. The error says: Cannot generate SSPI context Both SQL instance in the Active/Active cluster is being held by same node as of this moment. The default instance is not having problem as the second instance when it comes to windows authentication (even using same domain account). Any idea on what is the problem for this second instance of SQL? Thanks.
See: http://search.microsoft.com/search/…88&View=en-us&qu=Cannot generate SSPI context HTH Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>