Give the steps to follow to share Session state information using a SQL database..

 Posted by Bharathi Cherukuri on 7/25/2012 | Category: ASP.NET Interview questions | Views: 1196 | Points: 40
Answer:

Below are the steps to follow to share Session state information using a SQL database.

1) You have to set the sessionState element’s mode and sqlConnectionString attributes in the Web application’s Web.config file.
2) Secondly, you have to run the InstallSqlState.sql utility on the Session state server. This InstallSqlState.sql utility will install the SQL database which shares Session state information across processes.
The InstallSqlState.sql utility is installed in the \WINDOWS\Microsoft.NET \Framework\version folder when you install Visual Studio .NET Professional, Visual Studio .NET Enterprise Developer, or Visual Studio .NET Enterprise Architect editions.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response