• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

How do you open port 1434?

I need instruictions on how to open port 1434
0
J.R. Sitman
Asked:
J.R. Sitman
  • 4
  • 4
  • 2
  • +2
2 Solutions
 
timgreen7077Exchange EngineerCommented:
See the below link to show you how to open ports on the windows firewall

http://www.thewindowsclub.com/block-open-port-windows-8-firewall
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Open where? In Windows Firewall?
If so, then check this MSDN article.
0
 
Dave BaldwinFixer of ProblemsCommented:
You also have to have a 'listener' on the target machine.  Port 1434 is usually used by 'sqlbrowser.exe' which receives requests for named instances of SQL Server.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Sharon NowligeKeyboard NinjaCommented:
That would depend on which firewall you had now wouldn't it?

Sharon
0
 
J.R. SitmanIT DirectorAuthor Commented:
sorry, it took so long to post.  I followed the first article in the first post and added a rule to allow UDP port 1434.  When I telnet to it, it fails.

I need the port open for a program that was just installed that uses SQL.

What else needs to be done?
0
 
Dave BaldwinFixer of ProblemsCommented:
You probably need to install the SQL Native Client or Microsoft ODBC driver which includes the client code to connect to the 'sqlbrowser.exe' program on the SQL Server machine.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I followed the first article in the first post and added a rule to allow UDP port 1434.  When I telnet to it, it fails.
That's because you didn't give attention on that article. It teaches how to block a port and not how to allow it. Check the article I've provided and you'll should be able to allow traffic on port 1434.
0
 
J.R. SitmanIT DirectorAuthor Commented:
I understand, however, I 'allowed" it.

When I run a port scan on the server that currently has the program running.  It lists many 1433.  However on the new server is does not list any.  

port
0
 
J.R. SitmanIT DirectorAuthor Commented:
sorry posted the wrong image

port2.png
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
However on the new server is does not list any.  
Meaning that or you don't have SQL Server installed/started or it's installed and running but listening in a different port (named instances doesn't listening on 1433).
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Mr. Sitman, is this issue solved?
0
 
J.R. SitmanIT DirectorAuthor Commented:
sorry I took so long to award the points.

Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 4
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now