SQL Server uses TCP/IP to make connections between a client and a database. The default port it will use is TCP port 1433 and UDP port 1434, although this may be changed for your installation.
You may need to amend firewall rules either on your workstation, or your wider network to allow traffic to flow in both directions between machines running Syncsort™ Capacity Management applications and the SQL Server instance that hosts the database.
Named instances of SQL Server require a different port number per instance or requires the SQL Browser service to be running to resolve a name to an address and a port number. Consult with your SQL Server database administrators as to what is needed for your environment, if this is the case.