troubleshooting Question

PowerShell Port Opening SQL

Avatar of techgenious
techgeniousFlag for United States of America asked on
2 Comments2 Solutions980 ViewsLast Modified:
I'm looking for a powershell script that will open up various SQL ports.

TCP 1433 "SQLServer"
TCP 1434 "SQL Admin Connection"
TCP 4022 "SQL Service Broker"
 TCP 135 "SQL Debugger/RPC"
TCP 2383 "Analysis Services"
TCP 2382 "SQL Browser"
UDP 1434 "SQL Browser"

Can someone give me a script that opens these ports up via powershell.  I know how to do it via batch file:
netsh firewall set portopening UDP 1434 "SQL Browser"

netsh firewall set portopening TCP 80 "HTTP"


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros