skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Legacy Wire Protocol Driver : Connection Option Descriptions : Server
  
Server
Attribute
SERVER
Attribute
Address
Purpose
The location of the server.
Valid Values
IP_address | named_server | named_instance | server_name
where:
IP_address
is the IP address of the server to which you want to connect. Specify this address as: IP_address, port_number. For example, you can enter 199.226.224.34, 5000.
The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. See Using IP Addresses for details about these formats.
named_server
is the named server address of the server to which you want to connect. Specify this address as: named_server, port_number. For example, you can enter SSserver, 5000.
named_instance
is a named instance of Microsoft SQL Server. Specify this address as: server_name\instance_name. If only a server name is specified with no instance name, the driver uses the default named instance on the server.
server_name
is the nameof a server on your network. It must be an entry on the Alias tab of the SQL Server Network Client Utility or the network name of a server running Microsoft SQL Server. You can enter (local) when the driver is on the same computer as the Microsoft SQL Server database. You can connect to a local copy of Microsoft SQL Server, even when it is a non-networked version. Microsoft SQL Server 2000 and higher support multiple instances of Microsoft SQL Server running on the same computer.
Default
None
GUI Tab
General tab