Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Location
    Denver, CO
    Posts
    44

    Unanswered: SQL Server and Windows Firewall

    So I have my Windows Firewall setup with an exception for Microsoft SQL Server over port 1433. I made sure that my SQL Server Browser service is always running, and I used SQL Server Configuration Manager to ensure that the TCP/IP protocol does not use dynamic ports and only listens on port 1433. At first it was working great when I tried to access the database remotely. But then it just stopped working. I noticed when I disabled the firewall on the host machine, the remote machine could access the database immediately. And then when I turned the firewall back on, it was still able to access the remote database for a short period then it would be denied access again. Does anyone know why this might be the case?
    Paul Palubinski

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Not for nothing, but you should change the default port to something else
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2008
    Location
    Denver, CO
    Posts
    44
    Okay, so I figured out what the issue was in my case. I needed to add an exception for UDP port 1434 for SQL Server Browser in my Firewall and then everything was working great.
    Paul Palubinski

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •