amazon rds - bcp cannot connect to AWS SQL Server but SSMS can -

anyone know reason why bcp cannot connect sql server hosted aws while ssms can? have double checked server , user account details , both match.

i'm using generic command import csv file:

bcp db_name.dbo.table in "somefile_file.csv" -c -s xxx.rds.amazonaws.com -u username -p xxx -b 1000 

the error is:

sqlstate = 08001, nativeerror = 53 error = [microsoft][odbc driver 13 sql server]named pipes provider: not open connection sql server [53].  sqlstate = 08001, nativeerror = 53 error = [microsoft][odbc driver 13 sql server]a network-related or instance-specific error has occurred while establishing connection sql server. server not found or not accessible. check if instance name correct , if sql server configured allow remote connections. more information see sql server books online. sqlstate = s1t00, nativeerror = 0 error = [microsoft][odbc driver 13 sql server]login timeout expired 

is bcp using different port maybe?

the first error shows bcp uses named pipes protocol connect server. apparently, protocol inaccessible network connections.

on client workstation bcp run, check sql server configuration manager , ensure that, in client configuration list tcp/ip enabled , prioritised. strangely enough, bcp doesn't have command line switch protocol selection, way manage can think of.

p.s. option specify server address in form ip_address,port_number, don't think find option particularly attractive.