Solved

Automation error when launching excel from script asp

Posted on 2014-02-13
12
663 Views
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?
0
Comment
Question by:bensonwalker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
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.

HTH

Ivo Stoykov
0
 
LVL 1

Author Comment

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

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.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 1

Author Comment

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

Expert Comment

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

Author Comment

by:bensonwalker
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
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
 and APPID
{9209B1A6-964A-11D0-9372-00A0C9034910}
 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">
  <System>
    <Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
    <EventID Qualifiers="0">10016</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2014-02-14T14:10:25.500642300Z" />
    <EventRecordID>10018</EventRecordID>
    <Correlation />
    <Execution ProcessID="700" ThreadID="5540" />
    <Channel>System</Channel>
    <Computer>cissdev12.CISS.com</Computer>
    <Security UserID="S-1-5-82-1056898077-250033673-2746334084-1123725976-62429479" />
  </System>
  <EventData>
    <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>
  </EventData>
</Event>
0
 
LVL 33

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
0
 
LVL 1

Author Comment

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

Expert Comment

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

Author Comment

by:bensonwalker
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
0
 
LVL 33

Accepted Solution

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

Author Closing Comment

by:bensonwalker
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.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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