programatically find out is there''s a SQL installation

• mjschwenger

  SSCarpal Tunnel

  Points: 4019

  More actions

  July 20, 2005 at 6:44 am

  #167894

  Before installing my product, I need my module to find out if there's a SQL server already installed and what are the directories - SQL server installation directory and the datafiles and log.

  I'm trying to search into the registry keys, but getting confused when multiple instances and/or versions are installed.

  What will be the easiest way to do that?

  Can somebody send me an export from the registry where there are both SQL 7 and 2000. I do not have such anymore and I cannot include it into my code...

  Thanks,

  MJ

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  July 26, 2005 at 9:42 pm

  #577396

  Default Instance:

  Install Path: HKLM\Software\Microsoft\MSSQLServer\Setup\SQLPath

  If they are defined:

  Default Data File Path: HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\DefaultData

  Default Log File Path: HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\DefaultLog

  Named Instance:

  Install Path: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\Setup\SQLPath

  If they are defined:

  Default Data File Path: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>MSSQLServer\DefaultData

  Default Log File Path: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\DefaultLog

  K. Brian Kelley
  @kbriankelley

• philcart

  SSC-Forever

  Points: 47797

  More actions

  July 26, 2005 at 10:18 pm

  #577417

  You could also run script to check the services list using WMI.

   

   

  --------------------
  Colt 45 - the original point and click interface

• mjschwenger

  SSCarpal Tunnel

  Points: 4019

  More actions

  July 27, 2005 at 9:04 am

  #577592

  Thanks a lot, guys.

  What kind of script I can run to to check WMI?

  Is there a place to see an example?

  Thanks again, mj

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  July 27, 2005 at 9:16 am

  #577601

  Microsoft Script Repository:

  Services Scripts

  K. Brian Kelley
  @kbriankelley

• swoozie

  SSCrazy

  Points: 2770

  More actions

  July 2, 2014 at 10:12 am

  #1726560

  I am looking for someting similar and I must not be searching correctly.

  I was looking for either a T-SQL or WMI or even Powershell script that can scan a registry or server looking for specific SQL components.

  I saw some references to xp_regread but I do not want to use that undocumentec procedure in a scheduled daily policy check.

  I looked at the Script Repository but only found the VB scan tool.

  Any suggestions would be appreciated.

• swoozie

  SSCrazy

  Points: 2770

  More actions

  July 2, 2014 at 10:20 am

  #1726562

  I am looking for someting similar and I must not be searching correctly.

  I was looking for either a T-SQL or WMI or even Powershell script that can scan a registry or server looking for specific SQL components.

  I saw some references to xp_regread but I do not want to use that undocumentec procedure in a scheduled daily policy check.

  I looked at the Script Repository but only found the VB scan tool.

  Any suggestions would be appreciated.