Discover SQL Servers with Powershell

Posted on September 5, 2009, 5:21 pm, by Rhys, under Powershell.

With Powershell and SMO you can easily discover SQL Server instances running on your network in just a few lines of code.

?View Code POWERSHELL
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;
$smoObj = [Microsoft.SqlServer.Management.Smo.SmoApplication];
 
# This gets the sql servers available
$sql = $smoObj::EnumAvailableSqlServers($false)
 
foreach($sqlserver in $sql)
{
	Write-Host -ForegroundColor Green "Discovered sql server: " $sqlserver.Name;
}

discover sql servers with powershell

If this doesn’t seem to find all your sql servers check firewalls and the SQL Server Browser Service is running.

Tags: , ,
Comment (RSS)  |  Trackback

2 Comments

  1. Chuck Boyce says:
    December 22, 2009 at 7:51 pm

    Hi Rhys,

    The limitation of this is that unfortunately it relies on the SQLBrowser service. Discovery will not occur if the SQLBrowser service is not started.

    Chuck
    chuckboycejr

  2. Rhys says:
    December 22, 2009 at 9:10 pm

    Hi Chuck,

    Yep, no discovery without without SQLBrowser. It probably wouldn’t be difficult to remotely search the registry for installed SQL Server instances if this is an issue for you.

    Rhys

Leave a Reply

«
»