Create ASP.NET Session State Database

In command line window, navigate to .NET framework installation folder and run the following.

aspnet_regsql -S [server] -E -ssadd -sstype c -d [session state database name]

Reference: http://msdn.microsoft.com/en-us/library/ms178586.aspx