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).
The syntax for a server network address is of the form:
TCP :// < system-address> : < port>
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:
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.
- 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>].
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
7022and the named instance uses port
7033. The server network address for these two server instances are, respectively:
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
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
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
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
ALTER DATABASE AdventureWorks SET PARTNER ='tcp://[2001:4898:23:1002:20f:1fff:feff:b3a3]:7022';
To find the fully qualified domain name of a system, at the Windows command prompt on that system, enter:
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:
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.
TasksHow to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL)
Other ResourcesDatabase Mirroring
Help and InformationGetting SQL Server 2005 Assistance
17 November 2008
5 December 2005