community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Knowledge Base

Definitive answers from Server experts.
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.        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.      Additional Resources   Microsoft - Enabling COM Security Using DCOMCNFG 
View full article