How to find out what instances of SQL Server are installed on a PC

To find out what instances of SQL Server are installed on a Windows PC:

1. Open a Command window (In Windows 7, click Start button, enter: cmd <enter> in ‘Search programs and file’ field).

2. Enter: SQLCMD – L <enter> ┬áinto the command window. ┬áNote that the ‘L’ in the -L must be a capital L.

Here is an example from my PC:

SQL Server