Wednesday, December 21, 2011

Session Timeout in IIS 7 - Worker Process of ApplicationPool

Problem
Recently while testing my application, I was facing problem of Session time out.
By Default Session time is 20 mins and I wanted to extend it
Attempts
if we want to extend it we can set in web.config within System.web tag
<sessionState mode="InProc" timeout="30"></sessionState>
that I already have done.
I set it as 30 mins.
but still my session was getting timed out after 20 min.
So I doubt that it doesn’t apply to my Code so I set It by code also like
System.Web.HttpContext.Current.Session.Timeout = 30;

still no progress

Resolutions

after a long invastigation I came to know Its because Of Default Settings of ApplicationPool for the application in IIS.

There is a setting for Worker process of IIS which will set memory and resource to allot to application application wide.

in my case I was testing my application alone. So application was being idle for more than 20 min to check weather session is alive or not..

To open the settings refer the steps

  1. Type “inetmgr” in run window to open IIS
  2. from left pane “Connections” select your application.
  3. right click on your application and refer the image to open “Advanced Settings” of application(to check which ApplicationPool is referred by application )1
  4. from “Application Settings” window you can see the Name of ApplicationPool. like Asp.net V4.0, DefaultAppPool, Asp.net V4.0 Classic.
  5. now close both opened windows.
  6. from left pan double click on “Application Pools”, a list of created application pools will be displayed. if you want to create new application pool for specific application refer this
  7. Right click on the ApplicationPool that was assigned to your Application and click on "Advanced Settings...."
  8.  in the popup window ... check the Idle time out for ... that cause the timeout while web application is idle.
Here are the steps to set Idle time..

Happy Deploying...


Thursday, December 15, 2011

Steps to Remove Menu options in Export for Report Page in SSRS

Hi,
In SSRS(Sql Server Reporting Service), I wanted to remove extra options to export my report.

Here are the steps to remove option to export like (word, Excel, PDF, MHTML etc...) in SSRS (Sql Server Reporting Service)

Installation folder may be different from MSSQL.1, can be MSSQL.x (search for rsreportserver.config under Program Files\Microsoft SQL Server if not found)
Here are the steps for Disabling Excel Export Option in Reporting Services -
  1. Go to Database server where reporting services is installed, open the rsreportserver.config file located at <Drive Letter>:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer 
  2. Go to section.  
  3. Change this entry to i.e. add Visible="false" for Excel rendering extension 
  4. Same for PDF.  
Happy Reporting