Trouble connecting to my DB in Compass

Working with Data Developer Tools
,
1

I get this error in Compass querySrv EREFUSED _mongodb._tcp.sandbox.h0cha.gcp.mongodb.net. I whitelisted my IP address. User name and password were entered correctly. How to fix this?

2

Are you able to connect by shell?
Have you added correct IP in whitelist
If any VPN/firewall preventing your connection

4

I have mongo shell installed and when I paste the connection string in cmd it says:
DNSHostNotFound: Failed to look up service "":DNS operation refused.

Also, I’ve whitelisted it to access from anywhere, which includes my IP address.

I don’t have any VPN installed.

The thing is yesterday, it was working fine and I’ve not installed any new software till now to suspect that might have caused it.

5

It really has to be something local as the DNS information is correct as:

;; ANSWER SECTION:
_mongodb._tcp.sandbox.h0cha.gcp.mongodb.net. 59	IN SRV 0 0 27017 sandbox-shard-00-00.h0cha.gcp.mongodb.net.
_mongodb._tcp.sandbox.h0cha.gcp.mongodb.net. 59	IN SRV 0 0 27017 sandbox-shard-00-01.h0cha.gcp.mongodb.net.
_mongodb._tcp.sandbox.h0cha.gcp.mongodb.net. 59	IN SRV 0 0 27017 sandbox-shard-00-02.h0cha.gcp.mongodb.net.

If you can change the DNS resolver try with 8.8.8.8 and 8.8.4.4. They are the google’s public DNS server.