PowerShell ISE for Configuring SQL ACM

Document created by Matt Ray Expert on Aug 17, 2016
Version 1Show Document
  • View in full screen mode

In order for ACM to work with MSSQL then Net.Tcp Port Sharing Service must be enabled and started on all SQL VMs. In a large SQL environment PowerShell ISE can be used to remotely configure the service on all SQL instances.


First you will need a list of the SQL VMs that need to be configured, by default the script uses C:\Windows\Temp\VMs for this file. (The list should have VMs separated by a return, example below)



In order to conduct the setup simply open PowerShell ISE as an administrator. And run the following command:


$VMs = gc C:\Windows\Temp\VMs

Foreach ($VM in $VMs)


  Set-Service -Name NetTcpPortSharing -ComputerName $VM -StartupType Automatic -Status Running



After running the command the output should look as follows:


Once the configuration is complete you should be able to target SQL VMs from Turbonomic.

1 person found this helpful