Am trying to set up an ODBC connection between a Windows 2003 server and a remote MS SQL 2005 server. We have already done this with multiple customers successfully, but we've encountered a "Connection Failed" error at a specific customer site. Given that some customers work, we are certain that the SQL 2005 box we are connecting to is accepting remote connection via TCP/IP.
I ran a utility to test ports called Port Test, and confirmed that port 1433 is able to reach my SQL server host. We suspect that this maybe a firewall issue on our client side (not at the SQL host).
Am not sure what to ask my customer for, or if there's something else we need to do to unblock this error?