locked
ASP.Net session in sql server 2008 RRS feed

  • Question

  • User343518559 posted

    Hi,

    I am new to SQL Server mode session in asp.net application. How to add session to sql from the application.

    Somebody guide from the root...

    Monday, March 25, 2013 2:18 AM

Answers

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 25, 2013 5:58 AM
  • User-460739707 posted

    Hi,

    The following steps describe how to run the InstallSqlState.sql and the UninstallSqlState.sql script files to configure SQL Server mode session state management.

    1. In SQL Query Analyzer, on the File menu, click Open.
    2. In the Open Query File dialog box, browse to the InstallSqlState.sql script file, and then click Open. By default, InstallSqlState.sql is located in one of the following folders:

    system drive\WINNT\Microsoft.NET\Framework\version\

    system drive\Windows\Microsoft.NET\Framework\version\

    1. After InstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script.
    2. Before you run the UninstallSqlState.sql script file to uninstall SQL Server mode session state management configuration, you must stop the w3svc process. To do this, follow these steps:
      1. On the Windows Start menu, click Run, type cmd, and then click OK to open a command prompt.
      2. At the command prompt, type net stop w3svc. You receive confirmation that the w3svc process is stopped.
    3. In SQL Query Analyzer, on the File menu, click Open.
    4. In the Open Query File dialog box, browse to the UninstallSqlState.sql script file, and then click Open. By default, UninstallSqlState.sql is located in one of the following folders:

    system drive\WINNT\Microsoft.NET\Framework\version\

    system drive\Windows\Microsoft.NET\Framework\version\

    1. After UninstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script.
    2. After you uninstall SQL Server mode session state management configuration, you must restart the w3svc service. To restart the w3svc process, type net start w3svc at a command prompt.

    For further information, you can access to the below link: http://support.microsoft.com/kb/317604/en-us

    Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 29, 2013 6:12 AM

All replies

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 25, 2013 5:58 AM
  • User-460739707 posted

    Hi,

    The following steps describe how to run the InstallSqlState.sql and the UninstallSqlState.sql script files to configure SQL Server mode session state management.

    1. In SQL Query Analyzer, on the File menu, click Open.
    2. In the Open Query File dialog box, browse to the InstallSqlState.sql script file, and then click Open. By default, InstallSqlState.sql is located in one of the following folders:

    system drive\WINNT\Microsoft.NET\Framework\version\

    system drive\Windows\Microsoft.NET\Framework\version\

    1. After InstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script.
    2. Before you run the UninstallSqlState.sql script file to uninstall SQL Server mode session state management configuration, you must stop the w3svc process. To do this, follow these steps:
      1. On the Windows Start menu, click Run, type cmd, and then click OK to open a command prompt.
      2. At the command prompt, type net stop w3svc. You receive confirmation that the w3svc process is stopped.
    3. In SQL Query Analyzer, on the File menu, click Open.
    4. In the Open Query File dialog box, browse to the UninstallSqlState.sql script file, and then click Open. By default, UninstallSqlState.sql is located in one of the following folders:

    system drive\WINNT\Microsoft.NET\Framework\version\

    system drive\Windows\Microsoft.NET\Framework\version\

    1. After UninstallSqlState.sql opens in SQL Query Analyzer, click Execute on the Query menu to run the script.
    2. After you uninstall SQL Server mode session state management configuration, you must restart the w3svc service. To restart the w3svc process, type net start w3svc at a command prompt.

    For further information, you can access to the below link: http://support.microsoft.com/kb/317604/en-us

    Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 29, 2013 6:12 AM