http://forums.iis.net/1039.aspxForum targeting resolving issues on the IIS platform including tools such as DebugDiag, WFetch, etc.enCommunityServer 2007 SP1 (Build: 20510.895)http://forums.iis.net/thread/1881346.aspxMon, 06 Oct 2008 13:48:28 GMT50bcf3b4-f6fe-4638-adff-0c150e922e99:1881346Maxer_Ars0http://forums.iis.net/thread/1881346.aspxhttp://forums.iis.net/commentrss.aspx?SectionID=1039&PostID=1881346<span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">&nbsp;This is odd.&nbsp; If I stop and restart the SQL Server services and then go to the IIS machine to access a web application it will throw a &quot;Cannot generate SSPI context&quot; error when I load the application.&nbsp; </span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">However, if I restart the&nbsp;IIS machine&nbsp;(not the service, but the machine it is running on, restarting the service is not enough) then it works great again... until the next time I take SQL Server offline for maint/patches/etc... and then bring it back up.</span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">I looked at this article: <a href="http://support.microsoft.com/?id=811889"><span style="COLOR:blue;">http://support.microsoft.com/?id=811889</span></a>&nbsp; but Kerberos is NOT used.</span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">The ASP application runs under its own application pool which uses a specified Windows account to connect to SQL Server.</span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">The error log in the event viewer shows this: </span><font face="Calibri"><span style="FONT-SIZE:12pt;mso-fareast-font-family:&#39;Times New Roman&#39;;mso-ascii-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:&#39;Times New Roman&#39;;">Exception information: </span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;"></span></font><font face="Calibri"><span style="FONT-SIZE:12pt;mso-fareast-font-family:&#39;Times New Roman&#39;;mso-ascii-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:&#39;Times New Roman&#39;;">&nbsp;&nbsp;&nbsp; Exception type: SqlException </span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;"></span></font><font face="Calibri"><span style="FONT-SIZE:12pt;mso-fareast-font-family:&#39;Times New Roman&#39;;mso-ascii-font-family:Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:&#39;Times New Roman&#39;;">&nbsp;&nbsp;&nbsp; Exception message: Cannot generate SSPI context. </span><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;"></span></font><span style="FONT-SIZE:12pt;FONT-FAMILY:&#39;Times New Roman&#39;,&#39;serif&#39;;mso-fareast-font-family:&#39;Times New Roman&#39;;">So I&#39;m a bit confused by all this... thoughts?</span> <p>&nbsp;</p>