Todo Sharepoint: Sharepoint 2010

Pues bien SharePoint 2010 tiene la capacidad de manejar las sesiones Asp.net con total transparencia para el desarrollador, ya que toda la información de sesiones se almacena en una base de datos SQL.

Sin embargo esto también quiere decir que el uso intensivo de la sesión debe ser como siempre bien planificado.

Por defecto en una instalación estándar de SharePoint las sesiones Asp.net se encuentran deshabilitadas. Para habilitarlas en MOSS simplemente:

En la consola PowerShell ejecute

Enable-SPSessionStateService –DefaultProvision

Este comando establece los atributos por default dejando la base de datos de manejo de sesión en el mismo sitio que la base de configuración de SharePoint, si desea puede usar atributos adiciones para establecer dicha base de datos en otra ubicación.

DatabaseName

DatabaseServer

DatabaseCredentials

Este cmdlet solo esta esta disponible para MOSS, para Fundation debemos realizar esta configuración manualmente.

Y en el web.config de la aplicación web en donde desee habilitarlo establezca

<pages enableSessionState=”true”

SharePoint 2010 uses two services related to session state that have similar names but are separate and have different purposes.

ASP.NET session state may be used on SharePoint 2010 pages. This service is automatically disabled in normal installations of SharePoint 2010; it may be enabled using the instructions below. Once enabled, it appears on the Service Applications page as “SharePoint Server ASP.NET Session State Service.”
The State Service service application is designed for and only available to Office internal components such as InfoPath Forms Services and Visio Services. This service is automatically enabled in typical installations of SharePoint 2010 and is not related to ASP.NET session state. It appears on the Service Applications page as “State Service.”

To enable ASP.NET session state:

Enter the following PowerShell command in the SharePoint 2010 Management Shell window:
```
Enable-SPSessionStateService –DefaultProvision
```
On each web application for which you want to use session state, edit the web.config file and set the enableSessionState property of the pages element as follows:
```
<pages enableSessionState="true"
```

Guidelines for using SharePoint Server ASP.NET Session State:

This session state may be used by custom code in web parts and other page-hosted controls.
Session state information is stored in a configurable SQL database; this implies the following:
1. Load-balancer affinity is not required.
2. Heavy use of session state must be included in database/capacity planning. By default, the session state database is created on the same database server hosting the SharePoint 2010 farm configuration database. This can be changed to place it on another server; this can be done at a later date if necessary. To move it to another SQL server, it should first be disabled, then enabled again with different configuration that points to the other server.
When enabled, Session state is available to the whole 2010 farm. Each web application can choose to enable it for use on ASP.NET pages (enableSessionState="true").
Session state is partitioned using the root URL. This means that different web applications will have different session state objects; a web part can only access the session state object available to it. If host header site collections are used, then different session objects will be used for each site collection (the browser will have multiple session ids in different cookies).

Additional information about enabling session state:

Syntax 1

Enable-SPSessionStateService
-DefaultProvision

Syntax 2

Enable-SPSessionStateService
-DatabaseName <String>
[-DatabaseServer <String>]
[-DatabaseCredentials <PSCredential>]

Additional parameters are not discussed here; use Get-Help Enable-SPSessionStateService –full for more information.

The Enable-SPSessionStateService cmdlet creates a session state database, installs the ASP.NET session state schema, and updates the Web.config files on the farm to turn on the session state service.

If the DefaultProvision form of the command is used, all default settings are used. These are:

DatabaseName = “SessionStateService_<GUID>”
DatabaseServer = the same database server as the SharePoint 2010 configuration database
DatabaseCredentials = Integrated Windows Authentication

If the DatabaseName form of the command is used, then these parameters may be set explicitly. If some of the parameters are not included, they default as above. To set specific credentials for accessing the session state database, note that this allows you to specify a SQL Authentication credential only, not a Windows credential. Then, use the Get-Credential command to create a PSCredential object from a username and password, then use that object as the argument of the DatabaseCredentials parameter.

After this service is enabled, “SharePoint Server ASP.NET Session State Service” will appear on the Service Applications management page.

If you are trying to use session state in SharePoint 2010 to store data for use in web parts, application pages, etc. you may encounter the error below if session state is not properly configured and enabled for the web application.
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the \\<...
To resolve the error and to enable session state for SharePoint there are two entries that need to exist in the web.config file.
The first is to ensure that enableSessionState is set to TRUE.
<pages enableSessionState="true" enableViewState="true" enableViewStateMac="true"validateRequest="false"pageParserFilterType="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" asyncTimeout="7">
The second is to ensure that the remove and add lines exist in the modules section for Session.

…

…

modules>

Once you have made the modifications above to the web.config file you need to ensure that the State Service service application is running. You can check the status of this through Central Administation.
The error should now go away and Session State should be enabled for your web application.

Fuentes:

http://blogs.msdn.com/b/markarend/archive/2010/05/27/using-session-state-in-sharepoint-2010.aspx

http://blogs.itsynergy.co/blogs/lbernala/2010/09/17/manejo-de-sesion-asp-net-en-sharepoint-2010/

http://www.kajanmoorthy.com/2010/05/enable-session-state-in-sharepoint-2010.html

Más información:

http://www.c-sharpcorner.com/uploadfile/Roji.Joy/enable-session-in-sharepoint-2010/

http://code-journey.com/2011/enable-session-state-for-sharepoint-server-2010-and-foundation/