can you ping the destination server from the server you attempting you SQL connection? Have you tried to use: serverip, 1433 for a connection?

Hope this helps.

Thanks for responding. From the server that has the DSN created.. what should the IWAM account have access to?

Thanks