Unable to connect to SQL Server session database the connection string was returned by an instance of the IPartitionResolver type

Today, I was playing with authentication providers for setting up the site with anonymous access.

Suddenly the site started throwing the below error. I have no clue what’s wrong on the DB Server, then I restarted the DB Server no luck L

Exception:

Exception Type: System.Web.HttpException Exception Message: Unable to connect to SQL Server session database. The connection string (server=’Uday\Sharepoint’, database=’Uday_Content_DB’) was returned by an instance of the IPartitionResolver type ‘Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’

Solution:

It’s pretty simple close all your browsers and clear the browser cache J

Somehow the session is getting crashed.