Any time you specify a computer name it has to be resolved to an IP address by DNS server.

>So even when I use connection string (DNSless connection) a DNS server has to be involved, right?
>
>>When you define connection to a SQL Server (DSN, connection string, etc) you specify either SQL Server name or IP address. A DNS server resolves SQL Server name to its IP.
>>