Connection to SQL Server from Server on DMZ

  • I have a server that is sitting on our DMZ. I want it to be able to connect to our SQL server (not located on the DMZ). How do I do that? I don't know much about networking, so this is all new to me. Any help would be greatly appreciated.

    Thanks in advance!!!

  • Don't know how your dmz is set up, but I would talk to your network guys and see if they can open up a port for you.

  • Thanks for the reply ~

    Is there anything that needs to be done on the SQL server or the server sitting on the DMZ?

    From what I have read, it seems like port 1433 needs to be open. Please let me know if this is correct?

  • I would have a look at this article:

     

    http://support.microsoft.com/kb/250367

  • If you are doing SQL Server authentication (using the TCP port default) then you should only need the following ports:

    TCP 1433

    UDP 1434

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply