Automation error when launching excel from script asp

Posted on 2014-02-13
Medium Priority
Last Modified: 2014-02-14
I'm trying to use excel from within my asp script. I should point out that the script works just fine on my development machine (XP) after I granted access to the iusr and iwam accounts in com+. On the sever an error is logged in the system error log directing me to grant access to the iis apppool\dssolutions. Dssolutions is the name of the app pool. I'm able to do this but I still have the automation error being thrown. There must be something maybe else required on windows server 2012 iis that is missing?
Question by:bensonwalker
  • 6
  • 5
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 39858325
check permissions. the user iis runs under probably does not have privileges to read/wirte in the folder or/and excel application. Or there is no reference to the excel assembly.


Ivo Stoykov

Author Comment

ID: 39858709
I've done all that even changed the application pool identity to the administrator account and it still fails
LVL 34

Expert Comment

by:Big Monty
ID: 39859052
try giving the NETWORK SERVICES account access, depending on the windows version your new machine is, it'll require it.
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.


Author Comment

ID: 39859066
I tried that to. I granted network service launch and activations permissions in com+ , my computer properties, com security still no go
LVL 34

Expert Comment

by:Big Monty
ID: 39859090
can you post the full message you're getting?

Author Comment

ID: 39859104
Log Name:      System
Source:        Microsoft-Windows-DistributedCOM
Date:          2/14/2014 9:10:25 AM
Event ID:      10016
Task Category: None
Level:         Error
Keywords:      Classic
User:          IIS APPPOOL\Dssolutions
Computer:      cissdev12.CISS.com
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
 and APPID
 to the user IIS APPPOOL\Dssolutions SID (S-1-5-82-1056898077-250033673-2746334084-1123725976-62429479) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
    <EventID Qualifiers="0">10016</EventID>
    <TimeCreated SystemTime="2014-02-14T14:10:25.500642300Z" />
    <Correlation />
    <Execution ProcessID="700" ThreadID="5540" />
    <Security UserID="S-1-5-82-1056898077-250033673-2746334084-1123725976-62429479" />
    <Data Name="param1">application-specific</Data>
    <Data Name="param2">Local</Data>
    <Data Name="param3">Activation</Data>
    <Data Name="param4">{0C0A3666-30C9-11D0-8F20-00805F2CD064}</Data>
    <Data Name="param5">{9209B1A6-964A-11D0-9372-00A0C9034910}</Data>
    <Data Name="param6">IIS APPPOOL</Data>
    <Data Name="param7">Dssolutions</Data>
    <Data Name="param8">S-1-5-82-1056898077-250033673-2746334084-1123725976-62429479</Data>
    <Data Name="param9">LocalHost (Using LRPC)</Data>
    <Data Name="param10">Unavailable</Data>
    <Data Name="param11">Unavailable</Data>
LVL 34

Expert Comment

by:Big Monty
ID: 39859123
have you done the following steps?

1. Click Start -> Run -> Type -> dcomcnfg, expand Component Services -> Computers -> My Computer -> DCOM Config.
2. Click View -> Detail -> Now you will get Application Name and Application ID in right side.
3. Scroll down and find the application ID {AD65A69D-3831-40D7-9629-9B0B50A93843} -> Right Click -> Properties and select the Security tab.
3. Click Customize under "Launch & Activation Permission" -> click Edit -> Add in the account NT AUTHORITY\SYSTEM (and the other user accounts needed) and set local launch and local activation.
4. Restart the application Service linked to this Application ID or restart the server and monitor

Author Comment

ID: 39859176
I cant find that application id and when I browse users,groups, built-in security prinicipals I don't see the account?
LVL 34

Expert Comment

by:Big Monty
ID: 39859187
sorry, the account ID should be the one matched from your error log.

Author Comment

ID: 39859223
Yeah I figured as much that one points to Machine Debugger. I've shut that off in services but before that tried to give network service permissions but it's still throwing the error
LVL 34

Accepted Solution

Big Monty earned 2000 total points
ID: 39860181
i'm out of ideas then, hopefully someone else comes along and has a suggestion or two...

Author Closing Comment

ID: 39860213
The most obvious one.... rewrite the code to not use automation. Put response content type to msexcel and stream directly to browser. That fixed it.

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question