Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
DMZ to SQL server

Answered DMZ to SQL server

  • Wednesday, August 15, 2012 3:34 PM
     
     
    Sign In to Vote
    0

    I am tring to setup a program called Airwatch.  I have a DMZ server that needs to connect to the SQL server on the internal network.  We have a access rule to let the the 1433 port trafic though the firewall but, when tring to connect the two servers it is looking at 1434 to negotiate the sql trafic.  We have about five other server setup the same way and none of them are look at 1434.  I need to get this working asap.

    Thanks for your help.

     

All Replies

  • Thursday, August 16, 2012 1:02 AM
     
     Answered
    Sign In to Vote
    0

    This one may help or possibly ask them here.

    http://msdn.microsoft.com/en-us/library/ms175483(v=sql.105).aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/threads

     

     

     

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

     
  • Thursday, August 16, 2012 7:51 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    Thanks for posting here.

    I think it explained quite clear form the TechNet article Dave referred that two ports are required to open on firewall in order to remotely connect to SQL DB by default (TCP 1433/ UDP 1434) form external. So could we first reconfigure the rules on our firewall and see how is going ?

    Meanwhile, which firewall device are we using now ?

    Thanks.

    Tiger Li

    Tiger Li

    TechNet Community Support