How to configure SES components to communicate to Microsoft SQL Server on a non-standard port?
Article Summary:
This article provides information regarding scenario when a person would like to have SES configured to communicate thru a different port than the default port used (port 3700).
Proposed Solution
You can configure this change by following using format:
<Server Name> (DNS or IP address) followed by a <comma>, then desired <Port number>.
You will need to ensure that there are spaces in string.
Example:
ABCServer1,1234
NOTE:
When using Database Instance Names, either where the database has been defined to use named instances, or commonly where using Microsoft SQL Server Express Edition, where there's a default instance name, then the above configuration will look like this:
Example:
ABCServer1\InstanceName,1234
or
ABCServer1\SQLEXPRESS,1234
NOTE: There is another article on how to use SQL Aliases to accomplish the same thing, but SQL Aliases can provide further functionality as well. For further information please search our Knowledge Base for keyword "alias" to investigate that option.