• Are you on same machine when you try it from SSIS and SSMS? If not, could be a firewall or network issue when trying from SSIS.