Can't connect to remote SQL server from some machines
Here are some of the things from my connection issue checklist


Check for an alias on the machine that can't connect
Check for firewall rules
Check and make sure the SQL Server drivers on the machines that don't work are up to date.
Try connecting with servername:port rather than just servername
Try pinging the SQL Server IP address from the machines that can't connect.