FAQ 026: How can I configure DSN for the remote SQL server?

Check if that TCP/IP connection is enabled on the SQL server and the remote access to SQL server is configured properly. For example, check if port 1433 is opened in the Firewall and the router is properly set. (See your System Administrator for more details)