default port 1433 open

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  August 18, 2009 at 5:23 am

  #97975

  Hi,

  For the security purpose, I could checking sql port 1433 open or closed.

  >telnet ipaddress 1433,

  most of the servers port has been opend, if i block these sql server port, i want know whather application running or not. can anyone suggestion me,

  What impact happen on application side?

  thanks in advance

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  August 18, 2009 at 8:17 am

  #1040907

  are you looking to close port 1433 to prevent external clients from connecting to sql server?

  if so then just disable the TCP/IP server protocol and listen on shared memory only.

  so you are effectively only connecting to the database from the server itself? or are you also using named pipes???

  MVDBA