Post reply

programatically find out is there''s a SQL installation

  • 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

  • July 25, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • 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

  • 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

  • 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

  • July 27, 2005 at 9:16 am

    #577601

    Microsoft Script Repository:

    Services Scripts

    K. Brian Kelley
    @kbriankelley

  • 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.

  • 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.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply