Creating the ASP.NET Session State DB

So I know where to look this up the next time I re-forget it, the following cmd creates a session state db using integrated security.


C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe -ssadd -sstype c -d ASPState -S (local) -E 

Where:

S - db host/instance
E - use integrated security


Ensure that the login is also granted sysadmin privileges

To add the appropriate permissions:

use ASPState
grant EXECUTE on GetHashCode to "DOMAIN\Username"
grant EXECUTE on GetMajorVersion to "DOMAIN\Username"
grant EXECUTE on TempGetAppID to "DOMAIN\Username"
grant EXECUTE on TempGetStateItem to "DOMAIN\Username"
grant EXECUTE on TempGetStateItem2 to "DOMAIN\Username"
grant EXECUTE on TempGetStateItem3 to "DOMAIN\Username"
grant EXECUTE on TempGetStateItemExclusive to "DOMAIN\Username"
grant EXECUTE on TempGetStateItemExclusive2 to "DOMAIN\Username"
grant EXECUTE on TempGetStateItemExclusive3 to "DOMAIN\Username"
grant EXECUTE on TempGetVersion to "DOMAIN\Username"
grant EXECUTE on TempInsertStateItemLong to "DOMAIN\Username"
grant EXECUTE on TempInsertStateItemShort to "DOMAIN\Username"
grant EXECUTE on TempInsertUninitializedItem to "DOMAIN\Username"
grant EXECUTE on TempReleaseStateItemExclusive to "DOMAIN\Username"
grant EXECUTE on TempRemoveStateItem to "DOMAIN\Username"
grant EXECUTE on TempResetTimeout to "DOMAIN\Username"
grant EXECUTE on TempUpdateStateItemLong to "DOMAIN\Username"
grant EXECUTE on TempUpdateStateItemLongNullShort to "DOMAIN\Username"
grant EXECUTE on TempUpdateStateItemShort to "DOMAIN\Username"
grant EXECUTE on TempUpdateStateItemShortNullLong to "DOMAIN\Username"
go