Identity change in Application pool advanced settings.

Question

User-337513152 posted

Hi 

I have hosted the application on server and i have selected "DefaultAppPool" as app pool for my applicaiton.

In App Pool->DefaultAppPool->Advanced settings If i select "Identity" property as "ApplicationPoolIdentity", From my applicaiton i am unable to download the excel which is having more data.(Blank excel is downloading because failing to write more than 6000 records to excel).

So if i make App Pool->DefaultAppPool->Advanced settings->Identity as "localSystem", everything is working fine.

So could you please help me to download the excel with all data when pp Pool->DefaultAppPool->Advanced settings->identity as "ApplicationPoolIdentity" Selected.

--Thanks & Regards

Sunil

Answer 1

User-460007017 posted

Hi Sunil,

The difference between application pool identity and local system is that local system account has high level permission to access the file while application pool identity should be granted with the least permission to access the asp.net application. So if the local system works fine, you should try to grant read/write permission for application pool identity IIS Apppool\<your app pool name> to access the excel data. I assume the apppool identity doesn't have the permission to access the file out of the range of your website. You could also use process monitor to figure out where should the application pool identity being granted with permission.

https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx

This link provide the instruction to grant permission for application pool identity:

http://stackoverflow.com/questions/7334216/iis7-permissions-overview-applicationpoolidentity

Best Regards,

Yuk Ding

Answer 2

User-337513152 posted

Hi 

Thanks for the reply.

You said, We should try to grant read/write permission for application pool identity IIS Apppool\<your app pool name> to access the excel data.

Can you please explain me, where should i grant read/write permission for application pool identity ?

 Where i should provide IIS Apppool\<your app pool name> this ?

--Thanks & Regards

Sunil

Answer 3

User-460007017 posted

Hi Sunil,

Just grant the NTFS permission for application pooli dentity in right click properties->security.

To figure out where should you grant the permission, you could use process monitor to help you figure out the permission issue:

https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx

Best Regards,

Yuk Ding