Installing ASP.Net SQL Session State on IIS7

  • Thread starter Thread starter Robin9876
  • Start date Start date
R

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?
 
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)
 
Back
Top