This article describes Tricerat support for SQL Server ports, instances, and database aliases. The screenshots shown are v6 but is applicable to v7 installs too.

Background

Tricerat customers sometimes ask about configuration flexibility for static ports, dynamic ports, named instances, and database server aliases.

...

Tricerat supports configuring static ports, dynamic ports, named instances, and database server aliases for:

• Simplify Suite

• Simplify Print Server

• Tricerat Service Based Printers

SQL Server Name Syntax

The syntax for specifying a SQL Server name is <host name or IP><, port number><\instance name>

• <host name or IP> - This can be a machine name (resolvable by DNS) or an IP address.

• <,port number> - This can be a valid port number up to (and including) 65535.

• <\instance name> - This can be the name of an existing SQL Server instance 

Static Ports

By default, Microsoft SQL Server listens for incoming client connections on TCP/IP port 1433.

...

The following example configures a Simplify Suite installation to use SQL Server host TRICERAT-SQLDB and port number 11119:

Image RemovedImage Added

Dynamic Ports

The port number a given Microsoft SQL Server listens on can be configured dynamically by the server.

...

The following example configures a Simplify Suite installation to use SQL Server host SH-2008R2-SQL and named instance SIMPLIFY_TESTING:

Image RemovedImage Added

A named instance always corresponds to a specific port number.  In this sense a unique port number is equivalent to a named instance.

...

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client

Related articles