Excel Security – Interactive User Identity

Several LeapFrogBI processes use Excel to define configuration details such as FTP, HTTP, and MFS.  In some versions of windows, the Excel application is set to execute as the “Launching User”.  This causes a problem when using SQL Server Agent to access Excel Workbooks.  An error such as the following will be returned.


Description: Exception has been thrown by the target of an invocation.


The solution is pretty simple.  Set the Excel Application Identity to run as the “Interactive User”.  Here’s the step by step…


1. Open MMC Component Services.

32 bit OS – mmc comexp.msc
64 bit OS – mmc comexp.msc /32


2. Navigate to the Excel Application properties.

Computer > DCOM config > Microsoft Excel Application > Right Click to Properties


3. On the Identity tab select “Interactive User” & Click Ok.


All Done.  SQL Server Agent Run As credentials will now be able to launch Excel.



What We Do

We provide SMBs with custom data analytics services.

Built to Spec
We design custom solutions.

Low Cost per User
Empower as many report users as you like.

You Own It
Everything from the data solution to reports is yours to keep.

No upfront costs and no long-term commitment.

Available 24/7
We monitor and maintain everything 7 days a week.

Unlimited access to a team of data experts.

Find out how 
our clients
are getting

10x ROIwithin 6 months


Become Part of the LeapFrogBI Community

Join our newsletter to receive our latest insights and articles on automated, customized reporting in the healthcare industry.


Have any questions? Reach out to us, we would be happy to answer.