Create an ASPState database .
To generate an ASPState database you need to use the ASPNET_REGSQL command line application within the relevant Framework directory under the Microsoft.NET directory. I am using Windows Server 2008 R2 (64-Bit) so it is located in the C:WindowsMicrosoft.NETFramework64v2.0.50727 directory. A quick tip when using VistaWindows7Windows2008 if you hold down the Shift key and right-click in a blank space in Windows Explorer you get the option to ‘Open Command Window here’ just to save a bit of time and typing.
An example of a simple installation of the ASPState database would be; aspnet_regsql – ssadd -sstype t -S <servername> -U <username> -P <password>
For more details on the full list of command line options take a look at http://msdn.microsoft.com/en-us/library/x28wfk74.aspx
