How can I install session schema?

How can I install session schema if I want to use session state with sqlserver mode?

 

You either get the DASP support team to install the session state schema for you in an existing db or you do it yourself with aspnet_regsql.exe. More info here: http://msdn.microsoft.com/en-us/library/ms178586.aspx

 

Thanks CrystalCMS. Now, my hosting had this one. But it only works for the first time. After doing something (insert, update) with the db, I can not access my web pages unless I change the session back into InProc mode.
Could you tell me what the problem is?

 

Do you mean that you already have your site setup to use SQL Server session state, it appears to be working, but when you perform a database operation in some other unrelated table in your database, SQL Server session state appears to stop working?

 

Yeah, that's right.. I don't know what caused the problem. I could not open my web page, the browser show nothing. Note that hosting provider helped me make sqlserver session state available. Any suggestion?

 

It sounds strange but the first things that come to mind are:

• The session schema is not installed correctly
• The session schema is installed but is the wrong framework version
• Your code could be attempting to save something to session that is not serializable

Sorry that's all I can think of for now. Maybe support can advise further if they installed the schema for you.

 

Thank you, I think I should ask the support about this

 

You should contact support as mentioned in the following KB article:

http://support.discountasp.net/KB/a334/how-to-enable-aspnet-sql-server-session-on-your-web.aspx

You will need support to install the schema,and also include the Database name and the version of ASP.NET you are using in your request.