What are the steps to configure SQL Server mode?

 Posted by ArticlesMaint on 9/17/2009 | Category: ASP.NET Interview questions | Views: 3223

Following are the things to remember so that SQL SERVER Mode works properly: -

• SQL SERVER mode session data is stored in a different process so you must ensure that your objects are serializable.

• IIS met abase (\LM\W3SVC\2) must be identical across all servers in that farm.

• By default Session objects are stored in “Temped”, you can configure it store outside “TempDB” by running Microsoft provided SQL script.

Note: - “TempDB” database is re-created after SQL SERVER computer reboot.If you want to maintain session state with every reboot best is to run SQL Script and store session objects outside “TempDB” database.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response