From what I understood TLS is protocol independent of HTTPS and can be used with other protocols as well. For example in order to connect to MS SQL server via encrypted connection I'll have to enable TLS with cert on MS SQL server and I know that works.
My question is why it's not possible to leave MS SQL server without TLS configuration and put TLS termination on Load Balancer such as AWS NLB using TCP (TLS) listener that will just forward traffic after decrypting TCP packets to MS SQL server? What am I getting wrong in whole this TLS termination offloading to LB approach?