Home > Enterprise Desktop News > How to securely connect Windows NT Web server to SQL Server
Enterprise Desktop News:
EMAIL THIS

How to securely connect Windows NT Web server to SQL Server

By Robyn Lorusso, Editor
04 Oct 2004 | ITKnowledge Exchange

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

The following is the ITKnowledge Exchange Tip of the Week for Oct. 4, 2004.

Question

"rmartinez78" of Fastrac 24/7 Corp. writes:
I've got an NT Web server in our DMZ that can't connect to an internal SQL Server 7.0 database in Windows 2000. ODBC returns an access denied/can't find server message. When I put the Web server inside our net, ODBC works fine. Other servers in DMZ can connect to the database. What is going on?

Responses

  • "Howard2nd" writes: Lies, damn lies, and NetBios that won't die. This is about permissions and the lack thereof. 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.

    A 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.

  • "andy123" writes: Try the user company number.
  • 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.

    Start your own discussion

    Do you you have a Windows security dilemma that needs quick attention? Talk about it in ITKE.


    About the ITKnowledge Exchange
    ITKnowledge Exchange is a place where IT pros can share ideas, expertise and get answers to their technical and strategic questions. It provides direct access between groups or individuals who are grappling with similar IT issues in a safe and seamless environment. Click to start participating today or go to the Tip of the Week archives.


    Tags: Securing Windows legacy operating systemsVIEW ALL TAGS

    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


    RELATED CONTENT
    Securing Windows legacy operating systems
    Run legacy applications with Windows Vista security
    How to Bypass BIOS Passwords
    Security concerns of unattended, automatic installations
    How 'limited' malcode pulled off the year's biggest attack
    Taking over the domain
    How to get an attacker out of your network
    Checklists: Harden access control settings
    Freeware tool for password tracking and storage
    Manual vs. automated patch tracking
    Protect desktop files and folders from inside snoops

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    drive-by download  (SearchEnterpriseDesktop.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary



    Windows Desktop Technology - Virtualization, Virtual Infrastructure, Virtual Desktop
    HomeTopicsITKnowledge ExchangeTipsMultimediaWhite PapersBlogs
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2008 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts