Is Socket Error 10061 related to DNS resolution problems?

Yes, it can be. If the client cannot resolve the SQL Server's hostname to an IP address, it will attempt to connect using the hostname, which can lead to a 'Connection Refused' error. Ensure DNS resolution is working correctly on the client machine and that the SQL Server hostname is properly configured in the client's connection string.