SQL Server Performance Forum – Threads Archive
Cannot generate SSPI context errorHi, 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
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.