January 5, 2007 at 3:02 pm
What is sintax for BCP command for -S (server_name) when SQL Server is using non-default communication port ?
When I connect to SQL Server I have to type not just a server name in Server Name box, but listening post as well, like SERVERNAME,12345 . But in BCP coma does not work. Does anybody know the sintax for it ?
Thanks
January 6, 2007 at 1:54 am
I don't think it requires to specify the port number... BCP gets it dynamically port number...
If you want to specify you have to use like "-S SERVERNAME;12345 "
MohammedU
Microsoft SQL Server MVP
January 8, 2007 at 10:04 am
It might work if you created an alias for the server with the nonstandard port in the Configuration Manager on the client, then used the alias name in the BCP command.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply