<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>"Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx</link><description>Incorrect DNS can lead to various network connectivity issues. In this post, I explain how it affects your connection to SQL Server. In some cases, you may see the well-known "Cannot Generate SSPI Context" error message. 
 Suppose your SQL Server is</description><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: "Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#10420587</link><pubDate>Wed, 22 May 2013 12:37:03 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10420587</guid><dc:creator>Ederson Celestrino</dc:creator><description>&lt;p&gt;Esse erro para mim, era por causa do horário do Servidor, verifique data e hora também&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10420587" width="1" height="1"&gt;</description></item><item><title>re: "Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#9973255</link><pubDate>Fri, 05 Mar 2010 02:10:10 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9973255</guid><dc:creator>Sam</dc:creator><description>&lt;p&gt;We get this error if use TCP/IP. It works fine if we use Named Pipes.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9973255" width="1" height="1"&gt;</description></item><item><title>re: "Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#9065528</link><pubDate>Thu, 13 Nov 2008 09:36:23 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9065528</guid><dc:creator>Mohannad</dc:creator><description>&lt;p&gt;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!!! &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9065528" width="1" height="1"&gt;</description></item><item><title>re: "Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#9065527</link><pubDate>Thu, 13 Nov 2008 09:36:05 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9065527</guid><dc:creator>Mohannad</dc:creator><description>&lt;p&gt;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!!! &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9065527" width="1" height="1"&gt;</description></item><item><title>re: "Cannot Generate SSPI Context" error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#9052395</link><pubDate>Fri, 07 Nov 2008 18:40:12 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9052395</guid><dc:creator>samss.26</dc:creator><description>&lt;p&gt;Xinwei Hong,&lt;/p&gt;
&lt;p&gt;this post is quite informative and thanks for that.&lt;/p&gt;
&lt;p&gt;I'm getting an issue of same sort but not on very first attempt.&lt;/p&gt;
&lt;p&gt;My application works like below.&lt;/p&gt;
&lt;p&gt;1) It processes 10000 entities sequentially. while processing each entity application reads data related to that entity from SQL server.&lt;/p&gt;
&lt;p&gt;i.e. for processing each entity application talks to SQL&lt;/p&gt;
&lt;p&gt;2) This is a console application where i trigger the executable and it runs for 24 hours.&lt;/p&gt;
&lt;p&gt;All goes well with first 500 entities but suddenly application fails to process entities quoting this error &amp;quot;&amp;quot;Cannot generate SSPI context&amp;quot; error message&amp;quot;&lt;/p&gt;
&lt;p&gt;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?&lt;/p&gt;
&lt;p&gt;I would greatly appreciate your inputs on this. &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=9052395" width="1" height="1"&gt;</description></item><item><title>Steps to troubleshoot connectivity issues</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#8441862</link><pubDate>Wed, 30 Apr 2008 10:04:48 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8441862</guid><dc:creator>SQL Protocols</dc:creator><description>&lt;p&gt;We have been seeing and trying to resolve SQL connectivity issue all the time. I guess it would be helpful&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8441862" width="1" height="1"&gt;</description></item><item><title>SqlServerForum.org  &amp;raquo; Blog Archive   &amp;raquo; &amp;quot;Cannot Generate SSPI Context&amp;quot; error message, Poisoned DNS</title><link>http://blogs.msdn.com/b/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx#1614710</link><pubDate>Wed, 07 Feb 2007 02:33:52 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:1614710</guid><dc:creator>SqlServerForum.org  » Blog Archive   » "Cannot Generate SSPI Context" error message, Poisoned DNS</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://sqlserverforum.org/archives/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns/"&gt;http://sqlserverforum.org/archives/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns/&lt;/a&gt;&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=1614710" width="1" height="1"&gt;</description></item></channel></rss>