Skip to content

Three Easy Ways to Find Instances of Microsoft SQL Server on a Machine or Network

by on July 23, 2014

Discover All SQL Instances on a Network

This applies to instances not hidden using svrnetcn

It is my favored approach and usually what you (or your boss) is looking for.

at a command prompt > SQLCMD –L (capital L for List)

Look At Running Services on a Machine

Start > services (services.msc) > look for SQL Server (instancename)


Look In The Registry Keys on a Machine

Start > Regedit (regedit.exe)

Go to >  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names



Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: