Installing ASP.Net SQL Session State on IIS7

[Robin9876]

I have found to configure ASP.Net on IIS7 to use SQL Session State you
need to run aspnet_regsql.exe
Looking at the help file it appears that the connection string would
need permissions to create a database and objects on the server.

How can you create the SQL Session State database and then use a
different account for ASP.Net to use to add/maintain the session state
information within it?

 

[bruce barker]

yes. but you can create the database first if you want and use any name. you
may need to add the aspnet user.

you can also create the database in dev, and reverse engineer it with sql
workbench or a vs database project and create your own deploy scripts.


-- bruce (sqlwork.com)