How to change port when sqlcmd is called

Question

I have this team

sqlcmd.exe -E -i "C:\joe-db-scripts\joe-db-tasks.Install.sql" 

and I need to add a specific non-standard port 32001. How do I do this? I was thinking of some kind of flag like -p or something, but I don't know the syntax.

Answer 1

According to this MSDN link , you should use -S servername,32001 .

Answer 2

What it is: How to connect to the database engine using sqlcmd . Something like that:

 sqlcmd -S ComputerA,1691 

Answer 3

The following solution works for me in SQL Server 2008 and above.

sqlcmd -S "hostname or IP, port number" -U SA -P password