Permissions needed for SSIS Proxy account to import from Excel

Question

I have an SSIS package that runs from an agent job and imports an Excel spreadsheet into a database.

It will run just fine 'SQL Server Agent Service Account' is selected in 'Run as' but will fail with status = 'Unexpected termination' if I select the proxy account unless the proxy account is a member of the Administrators group on the server (which I want to avoid if possible)

Row 11 = run as 'SQL Server Agent Service Account'
Row 12 = run as 'SSISProxy' (my proxy account) where SSISProxy is not a member of Administrators in lusrmgr
Row 13 = run as 'SSISProxy' where SSISProxy is a member of Administrators in lusrmgr

Any ideas where to start? I've seen it suggested the proxy account needs read/write to the appdata area of the Default user profile but I've tried this and it hasn't helped

Answer 1

Hi @Ross ,

Go to Controlpanel --> Administrative tools-->Component Services -->computers --> myComputer -->DCOM Config --> Microsoft Excel Application.

right click to get properties dialog. Goto Security tab and customize permissions accordingly.

In Launch and Application Permissions, select Customize, Edit. Add the user / group that access the application.

And then use the account to run the job for a try.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @ZoeHui-MSFT , thanks for your response.

This machine does not have Excel installed, just the Microsoft Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-gb/download/details.aspx?id=54920)

Is there something else I should be looking for in Component Services?