Cliff Hobbs is a UK-based systems management consultant who specialises in the various systems management tools covered by his website FAQShop.com such as Microsoft System Center Configuration Manager (ConfigMgr) and Systems Management Server (SMS).Having worked with SMS since 1998 Cliff has gained extensive experience of designing, deploying, and supporting large enterprise-wide systems management solutions on behalf of companies such as EDS, 1E and Getronics.In recognition of his contribution to the Systems Management community Microsoft awarded Cliff the Most Valuable Professional (MVP) award for SMS in January 2004 which has been re-awarded in all subsequent years.Having grown up with the PC from the days of the IBM AT and PC-DOS 3.3, he has an extensive knowledge of several operating systems and applications gained through his present and past employment with companies such as EDS, Du Pont, Abbey National and Getronics, amongst others.The prime goal of FAQShop.com is to help people use Systems Management technology to make their lives easier - not for technology to control their lives which is reflected in this site's mission statement:
'Ensuring you get the best of IT'.
A couple of ways I've found are:
Look at the SQL Service names which contains the instance name:
For example if SQL has been installed to the Default instance the service name will be:
SQL Server (MSSQLSERVER)
If SQL has been installed to an instance called "SCCM" the service name will be:
SQL Server (SCCM) instead of SQL Server (MSSQLSERVER)
Look in SQL Server Configuration Manager:
Load SQL Server Configuration Manager (Start | Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Configuration Manager).
Once SQL Server Configuration Manager has loaded navigate to:
SQL Server Configuration Manager (Local) | SQL Server Network Configuration.
Under here you will find a list of all the SQL instances on the server in question prefixed by "Protocols for"
So for example if you have installed SQL to the Default instance you will see
Protocols for MSSQLSERVER
If SQL has been installed to an instance called "ConfigMgr" you will see:
Protocols for ConfigMgr
So if you have two instances of SQL running (one installed to the default instance and the other installed to ConfigMgr), you would see: