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:
