I am getting the below error message when configuring SQL Server Session State in Web Farm. Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object. Stack trace: at Microsoft.Office.Server.Administration.SqlSessionStateResolver.System. Web.IPartitionResolver.ResolvePartition(Object key) I cannot use InProc or adding Machine Name to the SQL Server as mentioned in this link http://blog.tylerholmes.com/2008/07/problem-with-sharepoint.html Any pointers are highly appreciated

To configure session state correctly, ensure you've followed this guidance. Start here: http://technet.microsoft.com/en-us/library/cc263527(office.12).aspx I trust that answers your question... Thanks C http://www.cjvandyk.com/blog

Thanks for your response ! But Session state is already enabled and i have one Sharepoint Site which is running fine on a web farm load balanced scenario. Now i am trying to add another sharepoint site. I am using the same App Pool Account and DB Credentials as the first one. But still getting the error. Thanks !

Hi Satish3, Please create another AAM for this site collection to have a try. Here is a similar thread, please take a look. http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/1c47cd79-4b9f-428d-bcef-a773bf2c44d8/ Best regards. Emir

Thanks all for your replies. At last I was able to fix this issue today. This is what i have done to resolve the issue in my case : 1) Created Custom Session DB using aspnet_regsql -S <DB Server Name> -d <DB Name> -ssadd -sstype c -U <User Name> -P <Password> 2) Commented the below line in the web.config of internet facing site (Used Custom Membership Provider and Role provider for authentication) <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> 3) Added the below connection string to connect to the custom session DB <sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="data source=<DB Server Name>;database=<DB Name>;user id=<UserName>;password=<Password>"/> 4) Added "NT Authority\authenticated users " to "Style Resource Readers" group 5) Browsed my application and now the error is gone and i am also able to see the session id and application in the below tables dbo.ASPStateTempSessions dbo.ASPStateTempApplications Hope this may help you !! Thanks Satish