How to Find All Sql Servers Installed on a Network

To check the number of SQL Servers installed on a LAN or network , we can use the following Commands on your commandline(cmd) :

  • osql -L
  • sqlcmd -L

Also , we can run the following command on Powershell to check the SQL Servers installed on a network with detailed results :

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

One thought on “How to Find All Sql Servers Installed on a Network

Leave a comment