October 6, 2015 at 7:00 am
I am setting up SQL 2014 always on.
I was able to set up the replicas between 2 servers in the same subnet.
Their IP addresses are say like this:
100.20.200.200
100.20.200.201
When I am trying to introduce another node into the cluster which has IP address like 100.10.101.102, I am getting an error that the server isn't reachable.
How do I get this working.
October 6, 2015 at 7:27 am
have you consulted your network admins?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 7:50 am
Perry Whittle (10/6/2015)
have you consulted your network admins?
what do I need to ask them?
I am able to ping the servers from each other
October 6, 2015 at 10:07 am
I would check the ports to make sure it's not blocked. If I remember correctly in the configuration manager you can set the active ports for TCP/IP to be dynamic or put in a static port number for each cluster instance. I set our clusters up with static ports that needed to be opened for traffic by our network admin. Might not apply to your setup but it was something I needed to do on ours 8 years ago.. 😛
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 6, 2015 at 10:48 am
Benki Chendu (10/6/2015)
Perry Whittle (10/6/2015)
have you consulted your network admins?what do I need to ask them?
I am able to ping the servers from each other
DNS settings are first to check, there are also a whole bunch of ports required when joining a node to a cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 11:17 am
Looks like they both are in different DNS servers. may be by the location of the servers, if you go into TCPIP Settings in Network configurations, you may need to add the other DNS server IP into DNS, it is basically lookup to find the server. your network admin will know the DNS server IP's, also try using Fully qualified Server name to see if that helps.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply