Lies, Damn Lies, and NetBios that won’t die. This case is ‘permissions’ and the lack there of. When your NT box is inside the firewall it can use netbios to resolve the server name. When it is outside the firewall it cannot and SHOULD not. ODBC uses the ‘Name’ of the server to connect.
Best practice would be to use the TCP/IP address instead of the ‘Name’, then ODBC won’t have to resolve the adress and there will be no ‘NetBios’ traffic. I quit using ‘names’ two years ago, and have no regrets. Using the TCP/IP address works in drive mappings, printer shares, ODBC, and eliminates the ‘name resolution’ hangup.
Remember that Win2k (and even more W2k3)is much stricter about ‘authentication’. Trusts must be explicit.
If by some chance your server uses dynamic addressing, WHY?