alteryx server Knowledge Base

Definitive answers from Server experts.

How to enable COM object on the server

Alteryx
Alteryx
Created

How to enable the use of COM object on the server

 

If you have written an external script to use a COM object, for example, Microsoft Excel and the workflow uses this, you will need to ensure that the appropriate permissions have been given to the group of users or specific users in order to run the script successfully on the Alteryx server. Otherwise, an error like below can be seen from the Windows System Logs:

 

 

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{XXX-XXX-XXX}
and APPID
{XXX-XXX-XXX}
to the user <ACCOUNT_USER> SID (XXX-XXX-XXX) from address LocalHost (Using LRPC) running in the application container XXX SID (XXX). This security permission can be modified using the Component Services administrative tool.

 

This article provides the steps to check and enable Microsoft Excel COM permission on the server. However, the same will apply to the other Microsoft COM objects or any third-party objects.

 

Prerequisites

 

  • Windows Operating System
    • Any versions
    • The administrator of the machine is needed.

 

Procedure

1. If Office 32-bit is used, please use the following command to bring up the Component Services:

mmc comexp.msc /32


For Office 64-bit, use the above command without "/32".

2. Look for "Microsoft Excel Application" in Component Services > Computers > My Computer > DCOM Config

 

clarab_0-1574307319208.png
 

 

3. Right-click on the component and select Properties.
4. In the Properties window, select the Security tab.
5. Choose the Customize option and click Edit for Launch and Activation Permission.
6. Select or add the appropriate group/user to access the COM object. Check Local Launch and Local Activation.

 

clarab_0-1574313689034.png

  

Additional Resources