CODEWITHSUNDEEP
asp.netiisweb-farmsession-state
Chuck
Chuck

Reputation: 53

How hard is it to setup a session state database for ASP.NET applications in an IIS farm?

How hard is it to setup a session state database for ASP.NET application running in an IIS farm?

I've received advice to never store anything at all in session state in my new ASP.NET 4 / IIS 7 application. This is following a discussion where I pointed out that this application will have low volume and store very little in session. The main justification I was given for this advice is that it would be extremely difficult to setup IIS and a database to store session state in our web farm.

Upvotes: 1

Views: 2120

Answers (1)

tvanfosson
tvanfosson

Reputation: 532465

Trivial if you have sufficient permission. All you need to do is run aspnet_regsql.exe with the proper options and connection string. You need to be able to create tables, stored procedures, user-defined data types, and a SQL job. Your DBA should have sufficient privileges to run this job if you don't. Make sure you use the .NET 4 version of the executable as previous versions differ.

You can find aspnet_regsql.exe in c:\windows\Microsoft .NET\Framework\<version>

Upvotes: 2

Related Questions