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)

clip_image001[5]

Look In The Registry Keys on a Machine

Start > Regedit (regedit.exe)

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

clip_image001[7]

AWESOME!

Advertisements
Leave a Comment

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: