Connect Microsoft SQL Database in DMZ

Posted on 2006-05-07
Last Modified: 2012-05-05
Hi All,

I do have one Server in DMZ running MS SQL, and I do have one PC in LAN want connect to the MS SQL Server in DMZ, but always connection fail.

Any idea how do I connect to the MS SQL Server in DMZ? What port should I open in Access Rules?


Question by:tut404
    1 Comment
    LVL 142

    Accepted Solution

    you have to open the port 1433 for sql server <-> your pc.
    note that you should change the default port (and hence use that port in the firewall rule also) of the sql server, open for that the Network Utilities in the sql server Start Menu

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now