Saturday, February 25, 2012

DB Mirror Problem

Hi,

I've got a problem with the DB mirroring in SQL 2005.

Configuration:

Server 1 Name: ABC001 NIC#1: IP 10.1.1.1 no DNS Server, no Gateway NIC#2: IP 192.1.1.11

Server 2 Name: ABC002 NIC#1: IP 10.1.1.2 no DNS Server, no Gateway NIC#2: IP 192.1.1.12

NIC#1 is an cross-over between the 2 server, NIC#2 is related to the local network.

I cannot setup the mirror with the built-in tool nor by hand.

With the tool I receive the message:

"

One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.

The syntax for a fully-qualified TCP address is:
TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>

"

By hand with (Endpoints are ready, added by the tool):

-- Specify the partner from the principal server

ALTER DATABASE [MyDB] SET PARTNER =

N'TCP://ABC002:5022';

also

ALTER DATABASE [MyDB] SET PARTNER =

N'TCP://10.1.1.1:5022';

makes a problem like "other server cannot be reached"

I can ping the other server and use windows sharing. I have create an host entry for ABC002 to use the NIC#1 alltime.

Has anyone an idea how to resolve this?

Thanks!

The error message is very clear.

Use FQON.

TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>,

For example:

TCP://mycomputer.mycompany.com:<port>

No comments:

Post a Comment