Avatar of janhoedt
janhoedt
 asked on

Ps and sql queries: firewall ports to open?

Hi,

I need to:
-connect to a server via powershell (execute invoke commands and enter pssessions)
-execute sql queries to another server

Both work on one w10 pc, not on another.
Which ports on the firewall I need to open
-for Powershell
-for sql queries?

Please advise
J
SecuritySoftware FirewallsPowershellSQL

Avatar of undefined
Last Comment
Qlemo

8/22/2022 - Mon
David Johnson, CD

sql usually communicates via tcp port 1433

Raheman M. Abdul

On the working WIN 10 PC, do you have SQL Browser service running? 

On non working PC, check the same service


Check sql modules installed on non working PC


McKnife

Firewalls have logs. Let the firewall log blocked connections and you'll see which ports are tried.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
janhoedt

ASKER
No answer on ps, only sql. Just generic Gooagable answer without details/clarification
McKnife

Don't close questions before asking for clarification. Makes no sense.
ASKER CERTIFIED SOLUTION
Qlemo

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.