Tempdb permissions problem upon restart

need to reset after every reboot

[mattglet]

i have a server that after EVERY reboot, i need to re-add permissions to the "tempdb" database to allow select, insert, update on these 2 tables: ASPStateTempApplications, and ASPStateTempSessions.

these are the two tables that store .Net's sessionstate, and applicationstate, so they are quite important.

has anyone else seen their permissions reset upon every reboot?

-Matt

[mattglet]

well, i found that the "tempdb" gets deleted, and recreated upon every restart (hence "temp"). i saw an article on how to create a sql command in your InstallSqlState.sql file that sets the permissions upon startup, but i'm not sure where to put the command. can anyone help?

-Matt

[mattglet]

just to post the answer to the problem:

you have set the session & application storage db to be the ASPState db (by using the InstallPersistentSqlState.sql file). it can then survive a server restart.

-Matt