November 21, 2010 at 9:13 am
Hello all,
We have been attempting to establish a mirror from a cluster to another stand alone server.
All servers are sql 2008 R2 Std edition.
We have established an IP address cluster resource that fails from node to node using an available NIC We have configured the mirroring endpoint on the cluster (principal) to use that IP address and port 7022.
We have a dedicated NIC on the stand alone box (mirror) and we have configured the endpoint to use the IP address and port 7022.
In the host file of each server set up
PrivateCluster IP address Principal
Private Stand Alone IP address Mirror
We sync the databases(take backups & restore with no recovery) issue the
ALTER DATABASE <db_name> SET PARTNER = 'TCP://Principal:7022'
GO on the mirror no problem
then on cluster ALTER DATABASE <db_name> SET PARTNER = 'TCP://Mirror: 7022'
GO
This errors out
and we see Database mirroring connection error 2 'Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.' for 'TCP://Principal:7022'. In the sql server error log
We have viewed netstat -ano and it seems the port 7022 is only associated with the public facing IP of the cluster.
We tried making changes in the sql server configuration manager. For IP address and setting the Private IP address there on the cluster and we still received the same result.
Then we tried establishing the mirror same as before but from the mirror server
ALTER DATABASE <db_name> SET PARTNER = 'TCP://Public IP address for SQL server:7022'
GO
then on cluster ALTER DATABASE <db_name> SET PARTNER = 'TCP://Mirror: 7022'
GO
This was successful. Our goal is to only use the dedicated NIC on the cluster for mirroring traffic. How do we accomplish this?
TIA,
November 21, 2010 at 12:13 pm
What operating system are you using on the cluster nodes and the stand alone server?
Is the stand alone server completely stand alone or is it a member of the same domain as the windows cluster nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 22, 2010 at 3:29 pm
OS = 2008 R2
yes all servers in same domain.
here is the solution
On cluster, you cannot configure SQL Server to listen on a specific IP addresses. You must choose IPALL. The IP addresses on which the cluster instance will be listening on is determined by cluster resources (configurable through Cluster Administrator, by adding IP Address resources under SQL Network Name resource).
SO add the private IP in CluAdmin, set the ip in the endpoints and away you go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply