SAS IOM Data Provider – Access Denied – SSIS connection [closed]

I’m looking for guidance into how to integrate with the SAS IOM Data Provider through SSIS. It works fine when using SAS software but when trying to connect using the SAS IOM Data Provider in SSIS I receive the error message “Access is denied”. The server name and credentials are identical.

Answer

Try and get the specific error message you receive and what O/S you are running on (SAS O/S and SSIS O/S). It is most likely using the wrong credentials. Check SSIS logs and the Event Viewer. You need to determine which system is rejecting the call. Most likely it is SAS which means you are coming across, to SAS, as a different user than you think you are.

Also, provide your connection string to IOM or double-check it at https://www.connectionstrings.com/sas-iom-provider/.