Thanks pete, this was resolved with the help of my tech team!
The host and port combination i was using had self signed SSL certificate, after going through some posts, i even tried to skip SSL verification but still had challenge to connect! Finally, i changed the port which was of http type and then could finally connect to DB.