Hi Team,
Am trying to connect my onprem sql server using matiilion,but its giving an time out message. Both matllion and sql server are in same VPN.
Am able to connect sql server using management studio.
Any one please help
Hello,
In which Cloud Service is your Instance in? (AWS/Azure/Google/DataBricks/etc)
If in AWS(same troubleshoot might work for others also), check your securitygroup port-opening allowance for outbound.
Fastest way to troubleshoot is to open ssh into the instance and try doing a telnet on the ip port. if it doesn't connect, it's blocked somewhere. (you can also try traceroute but I guess you need to install that one first into the instance)
If securitygroup is 'alright' there might be some onprem firewall blocking access, in that case the traceroute would probably identify 'how far' the connection goes through your network.
Hope this helps!
Br,
Michael