Skip to main content

Configuring ASP.NET website to use SQL Server for Session state

Today i was working on an application. So thought of storing the session in sql server. I will be installing on my notebook, my notebook name is yj-NB. I have set sa user password as sa123 on database. Here are the steps to follow:

Step 1:
Here is the code to add in web.config;

<sessionState mode="SQLServer"
sqlConnectionString="data source=yj-NB;UID=sa;PWD=sa123;"
cookieless="false"
timeout="20"/>

You don’t have to mention database name.

Step 2:

Installing the Session State Database Using the Aspnet_regsql.exe Tool
Go to command prompt
Systemdrive\WINDOWS\Microsoft.NET\Framework\version\

aspnet_regsql.exe -S yj-NB -U sa -P sa123 -d ASPstate -ssadd -sstype c

yj-NB: computer name

sa123: sa password

ASPstate: Database name that will be storing session
Labels:

Comments

Post a Comment

Popular posts from this blog

Clear Zimbra Mail Queue

If you want to clear mail queue from specific email address run the following command in your terminal. Below will remove mail queues, by checking FROM sender. eg. remove all mail queues sent by info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($7 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d Below will remove mail queues, by checking TO sender. eg. remove all mail queues sent to info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($8 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d
Post a Comment
Read more

Know your Lha Zha, Sog Zha, Shi Zha

There is believe in Buddhism, that an individual person have got their own lucky day and bad luck day in a week. They are derived from the twelve animals similar to chiness horscope. Your birth year tells you which Buddhism zodiac sign you below to. Lha Zha and Sog Zha are belived to be good day while Shi zha is consider bad day.
Post a Comment
Read more