title: SQL Server Ports
body: <p>We recently installed a sonic firewall on our network. We have a SQL 2005 express server that's configured to listen on dynamic ports. In its configuration manager the dynamic port number is set as 1067 with its default port still 1433.</p>
  <p>From my understanding we need to have the following ports open for it to work:</p>
  <blockquote>
  <p>Tcp 1433</p>
  <p>Tcp 1067</p>
  <p>Udp 1434</p>
  </blockquote>
  <p>Problem is we still cannot connect to the server from outside. When we switch off/disconnect the firewall we can can access the server.</p>
  <p>This tells me that the SQL server's setup is fine and the that the problem must be some port we are missing on the firewall.</p>
  <p>Any ideas?</p>