VIA Properties

previous page next page

SQL Server Configuration Manager Help

VIA Properties
	See Also

: : : : : : :

(Declaration)

Use the VIA Properties dialog box to view or specify the following options for the Virtual Interface Adapter (VIA) protocol.

Microsoft SQL Server must be restarted to enable or disable the protocol, or change the settings.

Options

Default Port: Default setting is 0:1433, in the format <network interface card number>:<port number>.

Enabled

Possible values are Yes and No. The VIA protocol is disabled by default.

Important:
The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Listen Info

Default setting is 0:1433, in the format <network interface card number>:<port number>.

When you list multiple ports, separate them with commas. This field is limited to 2047 characters.

Caution:
When more than one instance of SQL Server is installed, examine the port settings and configure each port to be used by only one instance. SQL Server prevents two instances from listening on the same port when using TCP/IP, but not when using VIA. If two instances are listening on the same port, incoming VIA connections may fail to connect, or connect to the unintended instance.