August 3, 2018 at 9:49 am
Good day,Please help with the following.I currently have two instances, initially I had only one network card, but I added one more.I have configured the new IP of the second card in the TCP / IP corresponding to one of the instances, the other one I have left with the other card.The inconvenience or doubt that I have, is why when connecting by the two IP always connects me only to one of the instances ?.I was doing tests, and I see that the instance to which the two IPs always connect was the first instance that was created.What I see is as if somehow the first instance created was by default receiving connections from all IP (cards configured) on the server.Any idea to be able to route each instance to the specified IP?I remain attentive, thank you very much.
August 3, 2018 at 12:36 pm
This sounds like a DNS issue to me. Your DNS server is likely pointing to the old address or prioritizing the old NIC.
You will want to update the DNS entry on your DNS server to prioritize the new NIC.
This webapge has a lot of information on setting up 2 NIC's in 1 machine:
https://www.mssqltips.com/sqlservertip/4928/configure-network-binding-order-for-a-windows-server-2016-failover-cluster/
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply