My SQL server runs on a non-default port. How can I specify this port in my connection string?

The data source component of your connection string should contain the port right after the IP address (or name). It should be separated from the IP by a comma.

data source=192.168.123.1, port number;

Take a look at this web site for great information on several connection strings.

http://www.connectionstrings.com/