I'm working from a new place and I'm unable to connect to a remote database using the wi-fi, but it works if I route my mobile 4g as a hotspot.
I've contacted the internet provider and they say there's nothing blocking the access. And it seems true because it allows me to connect to the VPN and I can access the remote desktop where the database is hosted and in there I'm able to connect to the database using SSMS without any errors, but when I try to connect directly from my PC I get the following error.
Any idea what could be causing this or how can I investigate where the problem is?
- I'm using SSMS v18.9.1, windows authentication and connecting using the server name like "srv123.xxxx.com\instprd". This configuration works when I use the 4g hotspot instead of the wi-fi.
CodePudding user response：
Tried what I could and then I talked to the ISP support and it was indeed that some ports were blocked. Some update on the router (tp link AC1200) firmware caused it so they had to downgrade it and that solved the problem.
CodePudding user response：
how to find server name
- open run
- write 'cmd'
- write in console window "Hostname"
your server name will show you