Error ASP 0177 : 8000401a creating Excel object in old ASP app iis7 and Windows server 2012

Question

I ported an old ASP application from Windows 2003 server running IIS6 to a Windows 2012 server running IIS (Version 8.0.9200) and now users cannot run ASP commands that generate Excel spreadsheets unless an Interactive User in logged into the Windows 2012 server.  The base IIS application is using Windows Authentication only. I have tried several different options for Application Pool Identity but receive the same error results.  DCOM has been configured to allow domain users full access to Excel.  Without a local user being logged in the ASP application users received the message below.

Server object error 'ASP 0177 : 8000401a'

Server.CreateObject Failed

/pugo/excel_construction.asp, line 94

8000401a

I solved this problem by changing the Microsoft Excel Application Property in DCOM Config of MMC.  Changed the Identity from "The interactive user" to "This user" and specified a local user and password.  I do not remember making this specification in IIS6 and Windows server 2003.

Thanks,

Michael

Answer 1

I solved this problem by changing the Microsoft Excel Application Property in DCOM Config of MMC.  Changed the Identity from "The interactive user" to "This user" and specified a local user and password.  I do not remember making this specification in IIS6 and Windows server 2003.

Hi mwoodardmcpw,

Although you seem to have the resolution for this problem, I still want to mention that it's not recommended to automate Office with Office PIAs on the server side, see this KB article:

https://support.microsoft.com/en-us/kb/257757

To avoid some potential problems, I recommend that you follow the suggestions in this KB article, to make a long-term solution.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.