Specifying a Server Network Address (Database Mirroring)

Setting up a database mirroring session requires a server network address for each of the server instances. The server network address of a server instance must unambiguously identify the instance by providing a system address and the number of the port on which the instance is listening.

Before you can specify a port in a server network address, the database mirroring endpoint must exist on the server instance. For more information, see How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL).

Syntax for a Server Network Address

The syntax for a server network address is of the form:

**TCP://<system-address>:<**port>

where

• **<**system-address> is a string that unambiguously identifies the destination computer system. Typically, the server address is a fully qualified ___domain name or an IP address:

  • To use an IP address, it must be unique in your environment. We recommend that you use an IP address only if it is static. The IP address can be IP Version 4 (IPv4) or IP Version 6 (IPv6). An IPv6 address must be enclosed within square brackets, for example: [<IPv6_address>].
    To learn the IP address of a system, at the Windows command prompt, enter the ipconfig command.

  • The fully qualified ___domain name is guaranteed to work. This is a locally defined address string that different forms in different places. Often, but not always, a fully qualified ___domain name is a compound name that includes the computer name and a series of period-separated ___domain segments of the form:
    computer_name**.domain_segment[....domain_segment]
    where computer_name is the network name of the computer running the server instance, and domain_segment[....**domain_segment] is the remaining ___domain information of the server; for example: localinfo.corp.adventure-works.com.
    The content and number of ___domain segments are determined within the company or organization. If you do not know the fully qualified ___domain name for your server, see your system administrator.

    Note

    For information about how to find a fully qualified ___domain name, see "Finding the Fully Qualified Domain Name," later in this topic.

• **<**port> is the port number used by the mirroring endpoint of the partner server instance. For information about specifying an endpoint, see How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL).
  A database mirroring endpoint can use any available port on the computer system. Each port number on a computer system must be associated with only one endpoint, and each endpoint is associated with a single server instance; thus, different server instances on the same server listen on different endpoints with different ports. Therefore, the port you specify in the server network address when you set up a database mirroring session will always direct the session to the server instance whose endpoint is associated with that port.
  In the server network address of a server instance, only the number of the port associated with its mirroring endpoint distinguishes that instance from any other instances on the computer. The following figure illustrates the server network addresses of two server instances on a single computer. The default instance uses port 7022 and the named instance uses port 7033. The server network address for these two server instances are, respectively: TCP://MYSYSTEM.adventure-works.MyDomain.com:7022 and TCP://MYSYSTEM.adventure-works.MyDomain.com:7033. Note that the address does not contain the name of the server instance.

  

  To identify the port currently associated with database mirroring endpoint of a server instance, use the following Transact-SQL statement:

  SELECT type_desc, port FROM sys.tcp_endpoints
  

  Find the row whose type_desc value is "DATABASE_MIRRORING," and use the corresponding port number.

Examples

A. Using a fully qualified ___domain name

The following server network address specifies a fully qualified ___domain name, DBSERVER8.manufacturing.adventure-works.com, and port 7024.

ALTER DATABASE AdventureWorks SET PARTNER ='tcp://DBSERVER8.manufacturing.adventure-works.com:7024';

B. Using IPv4

The following server network address specifies an IPv4 address, 192.168.19.46, and port 7023.

ALTER DATABASE AdventureWorks SET PARTNER ='tcp://192.168.19.46:7023';

C. Using IPv6

The following server network address contains an IPv6 address, 2001:4898:23:1002:20f:1fff:feff:b3a3, and port 7022.

ALTER DATABASE AdventureWorks SET PARTNER ='tcp://[2001:4898:23:1002:20f:1fff:feff:b3a3]:7022';

Finding the Fully Qualified Domain Name

To find the fully qualified ___domain name of a system, at the Windows command prompt on that system, enter:

IPCONFIG /ALL

To form the fully qualified ___domain name, concatenate the values of*<host_name>* and <Primary_Dns_Suffix> as follows:

<host_name>.<Primary_Dns_Suffix>

For example, the IP configuration

Host Name . . . . . . : MYSERVER

Primary Dns Suffix . . . : mydomain.adventure-works.com

equates to the following fully qualified ___domain name:

MYSERVER.mydomain.adventure-works.com

Examples

The following example shows the server network address for a server instance on a computer system named REMOTESYSTEM3 in another ___domain. The ___domain information is NORTHWEST.ADVENTURE-WORKS.COM, and the port of the database mirroring endpoint is 7025. Given these example components, the server network address is.

TCP://REMOTESYSTEM3.NORTHWEST.ADVENTURE-WORKS.COM:7025

See Also

Tasks

How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL)

Other Resources

Database Mirroring

Help and Information

Getting SQL Server 2005 Assistance

Change History