google spread sheets -db connection

Hi

i'm trying to establish a connection from google sheets  to azure db via the add on - so far with no luck

*i have white listed all the relevant ip's 

*Tried with the  Microsoft azure sql connector

*Tried with the  sql server  connector

*i do succeed to connect using the same set of credentials with another add on that is using the same google api's

Any ideas will be greatly appreciated

Thanks