Make sure you have your IP Scheme set before you deploy SQL Server 2019 Big Data Cluster

Published On: 2020-02-03By:

I was doing a POC of SQL Server 2019 Big Data Cluster (BDC) recently.  We did the POC in Azure as they didn’t have a Kubernetes environment on-prem that we could work with.  Everything they have in Azure is PaaS we the Kubernetes environment (and the vNet that it requires) were brand new.  I set up the BDC using Azure Data Studio and everything was working fine.  We went to set up the site to site VPN and found that the IP range that was used by default to set up the Kubernetes environment in Azure was already in use on their internal network (bad Microsoft, bad).

No problem, we just added in the correct IP range to the possible addresses for the vNet, added a new Subnet and moved the VMs over to the new subnet (which caused the VMs to reboot, but that was expected).

It turns on that BDC in SQL Server 2019 doesn’t like having the IPs changed for the aks nodes.  The problem stems from the fact that BDC is generating its certificates off of the IP address of the node, so if the IP address of the node changes (even if you are using DHCP for on-prem nodes and DHCP gives you a new IP address) your BDC won’t respond.

There are three possible solutions at this point.

  1. Change the IPs back to what they were before.
  2. Rebuilt the certificates that BDC uses based on the new IP Addresses
  3. Toss the BDC and build a new one

Option 1 wasn’t going to work as the old IPs were a conflict with on-prem

Option 2 isn’t great because this is a totally undocumented process to build the new certificates. So you have to figure out how to do this on your own. Given that our clients pay us by the hour, this is not really good use of their money or my time (mostly there money).

Option 3 was a really good option in this case, as there was no data in the environment. Just to be safe I tossed the entire Kubernetes environment and started from scratch.

The moral of this story is going to be, make sure you never need to change the IP addresses of the Kubernetes (or aks or k8s) that hosts your SQL 2019 Big Data Cluster after the fact.  Doing so will make your Big Data Cluster unusable; so when it comes to changing the IP address of your container environment and your running SQL Server 2019 Big Data Cluster, plan ahead.

SQL Server Big Data Cluster requires a good amount of planning in order to have a successful deployment.  The team at Denny Cherry & Associates Consulting would love to help you plan and deploy SQL Server Big Data Cluster with you.  Contact the team and we’ll get the process started.


The post Make sure you have your IP Scheme set before you deploy SQL Server 2019 Big Data Cluster appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC


Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link