Opening SQL Server ports

1153200 pts.
Tags:
SQL Server
Windows firewall
I'm looking to open up my SQL Server port through a Windows firewall but I'm struggling with the process. Is there a way I can find the ports that SQL is running on so I can open them?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Here is a link to the technet that will tell you how.  This works, I have done this before.

https://msdn.microsoft.com/en-us/library/ms177440.aspx

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    The first thing to do is run Google searches for phrases such as "sql server firewall ports". Numerous articles discuss numerous ports used by the Database Engine, Analysis Services, Reporting Services, Integration Services and possibly others. It can depend a lot on what all you need to access and from where the accesses will come.
    36,430 pointsBadges:
    report
  • Kevin Beaver
    You'll typically see MS SQL Server running on TCP and UDP ports 1433 and 1434. Running netstat -an|more at a command prompt can confirm this. There's also the Sysinternals program called TCPView (https://technet.microsoft.com/en-us/sysinternals/tcpview) that shows the open ports and the local processes tied each one.
    27,525 pointsBadges:
    report
  • Harisheldon
    If you are not sure how to check to see if the ports are running, you could check with your network techs and see if they could assist you in finding out what ports the server is using.
    12,915 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: