Open TCP Port Windows 7

I just went through this process to open ports 1433 and 1434 to allow access to MSSQL.
I've restarted the system and went to a site to test if the port is open and got negative results.
In control panel it says 1433 and 1434 is open for MSSQL.
Any ideas what is happening and why the tester is saying port is not open?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mr TorturSystem EngineerCommented:
The tester says not open because even if the ports are opened in your firewall on your pc, there is another thing (hardware firewall, router, anything) between you and the site that block these ports.
Well, I believe.
What is your situation, what do you want to do?
xoxomosAuthor Commented:
what do you want to do?
Ultimately to connect to SQLServer instance on my desktop from Mac running OS X.
About hardware firewall i don't know.  This is a university setting with the laptop on wireless and desktop wired .  You are suggesting a router in network services is blocking?
Besides your Router, or ISP blocking those ports, it is also possible that you aren't using the Windows builtin firewall but rather a 3rd party one. Many of the non-free AV suites include a totally unnecessary firewall, and then you'd have to configure that one and not the Windows built-in one.

One reason I don't like those suites.
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Dave BaldwinFixer of ProblemsCommented:
Ports are only open if there is a program listening on those ports.  On the machine with the SQL Database Server, port 1433 normally requires the sqlservr.exe service to be running and port 1434 expects the sqlbrowser.exe service to be running.  If they are not running then the SQL Database Server isn't running either.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
xoxomosAuthor Commented:
Yes sqlserver.exe is running and browser is running.  Looks like 1434 is UDP though.
xoxomosAuthor Commented:
Query tells me server is listening on 59726
Dave BaldwinFixer of ProblemsCommented:
1434 is normally UDP.  What query are you talking about?
xoxomosAuthor Commented:
use master
xp_readerrorlog 0, 1, N'Server is listening on'
xoxomosAuthor Commented:
Server is listening on [ 'any' <ipv4> 59726].
Server is listening on [ 'any' <ipv6> 59726].
xoxomosAuthor Commented:
Needed to go into config , protocols for sqlexpress, ip addresses, change that last one, ipall from 59726 to 1433.  Now at least i can see it listening on localhost.  
Next up try using tsql to connect from OS X.
Thanks all.
xoxomosAuthor Commented:
Thanks all
Dave BaldwinFixer of ProblemsCommented:
You're welcome.  My SQL Server was originally setup on port 1057 for some reason and I had to change that to get it to work on the 'standard' ports.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 7

From novice to tech pro — start learning today.