UPDATE: Since this is an instance under Amazon AWS, I created a ticket and eventually got help.

the issues ended up to be not related to sharepoint or SQL, it was a security conflict between two policies, one governing the internal subnet and one governing the DMZ.

Within those two, I did not have EXPLICIT exception to allow certain traffic between both.

Thank you guys for your informative questions.