How to connect a sql database hosted in Azure VM from from on-premise server. Please advice

There is absolute no difference in the way to connect to on-premise vs VM in the cloud; why do you think so?
You just have to take care that an existing FireWall allows the access.