Posted On July 8, 2019

PowerShell: 1-Liner to Discover SQL Servers on the Network

kimconnect 0 comments
blog.KimConnect.com >> Database >> PowerShell: 1-Liner to Discover SQL Servers on the Network
July 8, 2019July 8, 2019 kimconnectkimconnect 0 Comments

Run this command on server with SQL CLI installed (this will only detect SQL servers that has the SQL Service Discovery enabled)

PS C:\Windows\system32> [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

ServerName InstanceName IsClustered Version
---------- ------------ ----------- -------
TESTSQL01    SQLEXPRESS   No          14.0.1000.169
TESTSQL02      SQLEXPRESS   No          12.0.2000.8
TESTSQL02      SQLEXPRESS01 No          14.0.1000.169
TESTSQL02      SWPDM        No          12.0.4100.1
Categories:

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

Post Image

Read More

SQL: Use PowerShell to Validate if Database Exists

This function may be invoked remotely from a machine that has SQL-PS module installed. The…
Post Image

Read More

Microsoft SQL AlwaysOn High Availability Cluster Management Tool

There are some bugs in the script. I'm too lazy to go back a fix…
Post Image

Read More

Loading the SQL Server Management Objects (SMO)

function loadSMO{ $ErrorActionPreference = "Stop" $sqlpsRegistry="HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps" try{ if (Get-ChildItem $sqlpsRegistry -ErrorAction "SilentlyContinue") { throw "SQL…