Tuesday, July 05, 2011 4:13 PM
I am getting below Error when I request an report from .net application. In IIS i am using the anonymous user as one of our domain accounts.
Microsoft Office Excel cannot access the file '***********.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
When I use the local system user in IIS the report works. Not sure what accces has to be given to the Domian user in IIS.
Just to add a Point. I have checked the three points mentioned in the error message.
File and path exists.
no other application is running
and it is a different name from any other..
--> I have given the application pool account full control on the folder as well.
Any help or suggestions would be greatly appreciated
Tuesday, July 05, 2011 9:09 PM
Got it resolved by following the below steps.
Go to microsoft excel application in Dcom Congigaration and in properties use Interity user as the Domiain account used for Application pool
- Marked As Answer by SQL_Help Tuesday, July 05, 2011 9:09 PM
Wednesday, April 18, 2012 5:06 AM
I am also getting the same error
and i tried solution suggested by you but now I am getting new error
"Access is denied"
suggest me how to deal with it....
Thursday, August 16, 2012 11:20 AM
The following link helped to me and hopefully it will be also useful for you.