What are the steps to follow to share Session state information using a SQL database?-tech10032012

To share Session state information using a SQL database, follow these steps: 1. In the Web application’s Web.config file, set the sessionState element’s mode and sqlConnectionString attributes. 2. Run the InstallSqlState.sql utility on the Session state server. This utility installs the SQL database that 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. What are ASP.NET Custom controls? Custom controls extend the tools available to Web developers. Using custom controls, you can encapsulate key aspects of the visual interface and program logic that you want to reuse throughout your application, or throughout your organization.