How to find SQL Server tcp port with Powershell

Lol, if you don't have the port, can you connect to the SQL Server to query for it?

Posted by: Firmbyte | Dec 8, 2015 1:07:52 PM

@Firmbyte. Yes you can connect to a SQL Server instance if you don't have the port number. The SQL Server Browser Service allows clients to connect to SQL Server just with the SQL Server Instance name , such as MYSERVER\MYINSTANCE.
Quite often an error 26 is based on a Browser Client Service not being available. http://www.sqlserver-dba.com/2011/05/sql-server-error-26-troubleshooting-checklist.html

Posted by: Jack Vamvas | Dec 10, 2015 10:52:20 PM

Please try the below two liner for getting SQL Port details with Powershell. Replace $server with the computer name

$namespace = gwmi -computername $server -Namespace "root\microsoft\sqlserver" -Class "__Namespace" -Filter "name like 'ComputerManagement%'" | sort desc | select -ExpandProperty name -First 1

Get-WmiObject -computername $server -Namespace "root\microsoft\SqlServer\$namespace" -Class ServerNetworkProtocolProperty | select instancename,propertystrval,PropertyName,IPAddressName,ProtocolName | where{$_.IPAddressName -eq 'IPAll' -and $_.propertystrval -ne ''} | ft -autosize

Posted by: Kannan | Sep 12, 2016 3:45:26 AM

Make sure the wmi service is enabled

Posted by: Jack Vamvas | Sep 12, 2016 5:24:39 AM