"Cannot Generate SSPI Context" error message, Poisoned DNS

SqlServerForum.org » Blog Archive » "Cannot Generate SSPI Context" error message, Poisoned DNS

Wed, 07 Feb 2007 02:33:52 GMT

PingBack from http://sqlserverforum.org/archives/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns/

Steps to troubleshoot connectivity issues

SQL Protocols — Wed, 30 Apr 2008 10:04:48 GMT

We have been seeing and trying to resolve SQL connectivity issue all the time. I guess it would be helpful

re: "Cannot Generate SSPI Context" error message, Poisoned DNS

samss.26 — Fri, 07 Nov 2008 18:40:12 GMT

Xinwei Hong,

this post is quite informative and thanks for that.

I'm getting an issue of same sort but not on very first attempt.

My application works like below.

1) It processes 10000 entities sequentially. while processing each entity application reads data related to that entity from SQL server.

i.e. for processing each entity application talks to SQL

2) This is a console application where i trigger the executable and it runs for 24 hours.

All goes well with first 500 entities but suddenly application fails to process entities quoting this error ""Cannot generate SSPI context" error message"

My doubt is if this is the case with Kerboros authentication it should happen with very first record but it is not occuring there. why would it start throwing this exception in the middle?

I would greatly appreciate your inputs on this.

re: "Cannot Generate SSPI Context" error message, Poisoned DNS

Mohannad — Thu, 13 Nov 2008 09:36:05 GMT

Im using BizTalk server and SQL server, i faced the same Error .. the DATE was not the same on BizTalk server and SQL server !!! one of the guys did change the date. after changing the date and make it the same on the 2 servers everything ran fine!!!

re: "Cannot Generate SSPI Context" error message, Poisoned DNS

Mohannad — Thu, 13 Nov 2008 09:36:23 GMT