The mdac version that ships with Windows 2000 is 2.5, which is unable to dynamically determine the sql port (it does not connect to udp1434 to get this information), so you have to tell it the port that sql is running on. If your server is running on anything other than 1433 then you'll run into this problem.