Watch keynotes and sessions from MongoDB.live, our virtual developer conference.

Trouble connecting to my DB in Compass

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?

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

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 Ive not installed any new software till now to suspect that might have caused it.

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.