Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Think about the situation that you have a software audit. The company use a software facility management tool to determine installed software on a machine. This software that seek for installed software is able to create packages to find software.

At the moment the software seeks for special registry keys to see if sql server is installed.

I got a false alert on one machine, because there only management studio (client tools) are installed. So I need to identify if the full server database server is installed or client tools only. Can I determine this finding registry keys?

share|improve this question
up vote 3 down vote accepted

take a look here :

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSQLServer HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server

SQL Server 2008 R2

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersionSQL

SQL Server 2008

  • SQL Server Native Client 10 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion

SQL Server 2005

  • SQL Server Native Client 9 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion
share|improve this answer
I knew the software keys, already checking them, but this don't tell me if there is just client tools installed or a server running. But checking the existance of a sql server service will do it, good idea. – YvesR Jun 14 '12 at 14:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.