I'm having trouble getting an SSIS package to access an ODBC connection via a domain account set up as a proxy user. If I grant the domain account local administrator on the SQL Server, the package will connect with the ODBC connection. If I log into the Windows server as that user, the package will run successfully.
What needs granted to the domain account in order to read a system ODBC connection? Domain users already have read access by default. This may be a case where the ODBC driver isn't able to run without the user being able to spawn processes?
Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
The AcquireConnection method call to the connection manager [ODBC Connection Name].[Username] failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Thanks.

