Error with Excel and C# when logged off the server

Question

0.00/5 (No votes)

See more:

Hi,
I have written a windows service in C#, my service is meant to open an excel macro enabled workbook (this is in Excel 2010) i have installed this service on our server which is running server 2008, it is 64 bit. My service seems to have a problem launching Excel when no one is logged on the server, does anyone have a solution to this.

i get the following error

System.Runtime.InteropServices.COMException (0x8000401A): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.

Excel is installed on the server, the service works fine when i am logged on the server but once all users have logged off i get the above error. i would like the service to launch my excel work book regardless of an open sesson on the server or not.

Posted 30-Jan-12 18:45pm

RowenaReddy

Updated 19-May-19 14:14pm

Rajesh Anuhya

v2

Add a Solution

Comments

Rajesh Anuhya 31-Jan-12 0:54am

Edited for readbulity.
--RA

Herman<T>.Instance 31-Jan-12 4:07am

what user is running the service? Does that user have enough rights to start excel?

RowenaReddy 31-Jan-12 4:56am

Well Digimanus thx you for your response, i think so, but just so i know i am doing it correctly, how would you check if the User has enough permissions?, i also tried what was mentioned in the discussion you referred me to and changing the identity in the Dcom Config properties for Microsoft excel application to this user worked, but to my dismay, our company will not allow this as it is not best practice, so i am now trying to find a different way around this. Any other ideas?

Herman<T>.Instance 31-Jan-12 9:25am

set the excel file in MyDocuments folder of the user the service uses. It should have apprpriate rights then.

4 solutions

Solution 1

More help found here: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/2f923b6d-aebb-42ff-804d-21a3763d491b/[^]

Posted 30-Jan-12 22:08pm

Herman<T>.Instance

Solution 3

Error with Excel and asp.net when logged off the server

i give all permission in Excel application but not resolve the Error.

1. Go to the Start-Run menu to type in "dcomcnfg" and hit enter to load "Component Services" MMC.
2. Select the "Microsoft Excel Application" item through "Component Services" MMC->Component Services->Computers->My Computer->DCOM Config->Microsoft Excel Application
3. Right click and select Properties->Select Identity Tab->Select This user and add the Administrator accout and password
4. Select Security Tab, Under "Launch and Activation Permissions", Choose "Customize", Click "Edit" button, Add the everyone account and add all the Permissions.
5. Do the same thing in "Access Permissions" and "Configuration Permissions"

CSS

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046}
failed due to the following error: 8000401a.

at SimplifiedReports.export(Int16 index, Feeder feed, Int16 submission) at
SimplifiedReports.btnExportExcel_Click(Object sender, EventArgs e) at
System.Web.UI.WebControls.Button.OnClick(EventArgs e) at
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String
eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint)
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046}
failed due to the following error: 8000401a.
Project id 123
Client TANEJA VIDHYUT CONTROL PVT. LTD.
Project UNITECH INFOSPACE SEZ-TIKRI, GURGAON 140621-E

Please reply me...

Pankaj Tripathi

Posted 8-Jul-14 19:15pm

pankaj1985tripathi

Solution 4

you can create another user , then login with that and create remote to 121.0.0.1 and main user (loopback to rpc!!!) then diconnect from new user and you will have interactive user

Posted 19-May-19 14:14pm

Kachal Khan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thichhochoi · Accepted Answer · 2012-12-14T22:07:00

CSS

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.


It should be the permissions problem.
Please have a try using the following steps to Configure DCOM:
1. Go to the Start-Run menu to type in "dcomcnfg"  and hit enter to load "Component Services" MMC.
2. Select the "Microsoft Excel Application" item through "Component Services" MMC->Component Services->Computers->My Computer->DCOM Config->Microsoft Excel Application
3. Right click and select Properties->Select Identity Tab->Select This user and add the Administrator accout and password
4. Select Security Tab, Under "Launch and Activation Permissions", Choose "Customize", Click "Edit" button, Add the everyone account and add all the Permissions.
5. Do the same thing in "Access Permissions" and "Configuration Permissions"