Post reply

SQl08R2 firewall - best practices?

  • July 7, 2011 at 1:44 pm

    #243717

    hello i have SQL08R2 and MS show-how links describe opening firewall holes for certain ports DO NOT work.

    when trying to connect from SSMS i get blocked, when i turn off the firewall i get in.

    i tried a bunch of mentioned ports but it still doent work, i cant find the DB on the network discovery of SSMS and direct IP yields the same result.

    anyone has a link to a solid how to?

  • July 7, 2011 at 1:52 pm

    #1350005

    Are you referring to the windows firewall in the OS ? Have you added an exception to the default port for sql server 1433 under the windows firewall ? What happens when u try a telnet ? Are u facing the issue only when connecting via SSMS ?

    Jayanth Kurup[/url]

  • July 7, 2011 at 1:54 pm

    #1350009

    How is your instance configured? Are you using the default port? Is this is a default instance installation? Did you open the ports for all of relevant tcp and udp ports?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 7, 2011 at 2:13 pm

    #1350028

    If he's using a default instance then simply openning TCP port 1433 should be sufficient. For a named instance you can look at the errorlog and it will tell you what port it is using, THAT port would need to be opened as well. If you have SQL Browser running you need UDP port 1434 open I believe.

    CEWII

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

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