janhoedt

<div>
<p>On the working WIN 10 PC, do you have SQL Browser service running?&nbsp;</p><p>On non working PC, check the same service</p><p><br></p><p>Check sql modules installed on non working PC</p><p><br></p>
</div>


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




<div>
Firewalls have logs. Let the firewall log blocked connections and you'll see which ports are tried.
</div>


Firewalls have logs. Let the firewall log blocked connections and you'll see which ports are tried.

<div>
No answer on ps, only sql. Just generic Gooagable answer without details/clarification
</div>


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

<div>
Don't close questions before asking for clarification. Makes no sense.
</div>


Don't close questions before asking for clarification. Makes no sense.

Developer & Coffee Roaster

Scott Fell

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to:<br />
-connect to a server via powershell (execute invoke commands and enter pssessions)<br />
-execute sql queries to another server<br />
<br />
Both work on one w10 pc, not on another.<br />
Which ports on the firewall I need to open<br />
-for Powershell<br />
-for sql queries?<br />
<br />
Please advise<br />
J
</div>
</div>


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

Ps and sql queries: firewall ports to open?

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.

Security

Software firewalls, also known as host-based firewalls, provide a layer of software on one host that controls network traffic in and out of that single machine. Most operating systems now include firewall software, but many available software firewalls include central distribution, antivirus systems and disaster recovery.

Software Firewalls

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.