SQL Server ODBC Configuration

Tags:
Database Management Systems
SQL Server
Tech support
I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Andy123
    Hi, Install the SQL Client Network tools from SQL CD onto the NT server. Create an alias (if you want a name) linked to an IP and Port. Make sure you use tcp/ip. For additional security you may want to change the listening port for SQL on the server and client side from the default. If you need any help, please reply to the forum. cheers Andy
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following