Hi, I am trying to use the ODBC Data Source Administrator to create a datasource to grab info from a database on another server. Creating the System DSN, I choose Add and then SQL Native Client. I put in the correct machine name (which can be pinged), the correct user name and password (sa and it's password) - on the database server, it has TCP and Pipes enabled, as well as remote connections. But the "Connection is actively" refused keeps coming up. Why is this?

Thanks,
James