My application is built on ASP.NET 2.0 and is hosted on a dedicated server running Windows Server 2008 R2.
From the last few days, my users are complaining that the application starts malfunctioning by picking previous SQL Server connection values. The GridView starts displaying options of a DropDown control and so on. When I restart the SQL Server background
service, everything starts working fine. I had a lot of discussion with people and few suggested that it has something to do with the Application Pool.
I looked into the IIS properties to see which application pool is running my application. I found that my application is using
Classic Application Pool with Managed Pipeline Mode set to:
Classic. The application is also running with Application Pool Identity set to
LocalSystemAccount.
In the database connection string (in web.config file), I am using Server Name as
LocalHost with Integrated Security=SSPI.
I want to know whether the above settings have anything to do with this malfunction.
Do I need to change the Pipeline Mode to Integrated and put the application in a separate pool? Is Integrated Security=SSPI has anything to do with the PipeLine Mode?
When I change PipeLine Mode from Classic to Integrated, my application stop working. It gives some error of permissions. I don't remember the exact error.
How to create a separate pipeline for my application and what are the advantages?
rpk2006
Member
631 Points
629 Posts
Is Integrated Security linked to App.Pool's Pipeline Mode and Identity?
Feb 23, 2012 09:53 AM|LINK
My application is built on ASP.NET 2.0 and is hosted on a dedicated server running Windows Server 2008 R2.
From the last few days, my users are complaining that the application starts malfunctioning by picking previous SQL Server connection values. The GridView starts displaying options of a DropDown control and so on. When I restart the SQL Server background service, everything starts working fine. I had a lot of discussion with people and few suggested that it has something to do with the Application Pool.
I looked into the IIS properties to see which application pool is running my application. I found that my application is using Classic Application Pool with Managed Pipeline Mode set to: Classic. The application is also running with Application Pool Identity set to LocalSystemAccount.
In the database connection string (in web.config file), I am using Server Name as LocalHost with Integrated Security=SSPI.
I want to know whether the above settings have anything to do with this malfunction.
Do I need to change the Pipeline Mode to Integrated and put the application in a separate pool? Is Integrated Security=SSPI has anything to do with the PipeLine Mode?
roopeshreddy
All-Star
20155 Points
3328 Posts
Re: Is Integrated Security linked to App.Pool's Pipeline Mode and Identity?
Feb 24, 2012 09:41 AM|LINK
Hi,
Try to create Pipeline to Integrated Mode and create a separate pipeline for your app!
Hope it helps u...
Roopesh Reddy C
Roopesh's Space
rpk2006
Member
631 Points
629 Posts
Re: Is Integrated Security linked to App.Pool's Pipeline Mode and Identity?
Feb 24, 2012 09:50 AM|LINK
When I change PipeLine Mode from Classic to Integrated, my application stop working. It gives some error of permissions. I don't remember the exact error.
How to create a separate pipeline for my application and what are the advantages?
roopeshreddy
All-Star
20155 Points
3328 Posts
Re: Is Integrated Security linked to App.Pool's Pipeline Mode and Identity?
Feb 24, 2012 09:59 AM|LINK
Hi,
Sorry for the wrong name - It's Application Pool!
Try to create a separte Application Pool for your web application!
Hope it helps u...
Roopesh Reddy C
Roopesh's Space
rpk2006
Member
631 Points
629 Posts
Re: Is Integrated Security linked to App.Pool's Pipeline Mode and Identity?
Feb 24, 2012 11:01 AM|LINK
But why it gives error when Pipeline Mode is Integrated?