Persistent ASP Session store can reside in either "tempdb" or "aspstate" database in SQL Server 2005. The sqlConnectionString parameter, in sessionState doesn t specify this (example below). How is this resolved?
<sessionState mode="SQLServer" sqlConnectionString="Server=mysqlserver;Integrated Security=SSPI;" cookieless="false" timeout="20" />