« Previous Next »

• 10-06-2008, 9:48 AM

  Maxer_Ars Joined on 02-27-2008, 1:20 PM Posts 21

  “Cannot generate SSPI context” after SQL Server service restarts with an ASP.NET app on IIS Reply Contact  This is odd.  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 "Cannot generate SSPI context" error when I load the application.  However, if I restart the IIS machine (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.I looked at this article: http://support.microsoft.com/?id=811889  but Kerberos is NOT used.The ASP application runs under its own application pool which uses a specified Windows account to connect to SQL Server.The error log in the event viewer shows this: Exception information:     Exception type: SqlException     Exception message: Cannot generate SSPI context. So I'm a bit confused by all this... thoughts?