The following command creates a database named ASPState on a SQL Server instance named "YourSqlServerInstanceName" and specifies that session data is also stored in the ASPState database:
aspnet_regsql.exe -S YourSqlServerInstanceName -E -ssadd -sstype p