How to check if SQL 7 is installed

[techkate]

What are the registry entries that I can check to ensure that SQL Server 7 w/ SP4 is installed? I tried some searches on this site and google but couldn't find any valid links/answers.

I probably just couldn't get the wording right though. Could anyone provide me with the information or at least guide me in the right direction? Thanks for your time,

Kate

 

[JayKusch]

If you have Query Analyzer available, enter the following command ...

SELECT @@Version

SQL Server 7 SP4 will have a number in this range:

7.00.1063 (SP4)
7.00.1077 (SP4 + Q316333)
7.00.1094 (SP4 + Q815495)

Thanks

J. Kusch

 

[techkate]

I'm sorry I probably need to be more clear. My mornings are pretty rough until late afternoon (...hehe...). My apologies.

This isn't necessarily for an existing unit to see what version is currently installed.

This is for an installation. I would like to search the registry on the destination unit and display an error message if I find that SQL 7 is not installed. I'm unsure of the standard registry entries that SQL 7 places on a unit on which it exists. If I can determine the Service Pack, that would help too.

Thanks!

 

[techkate]

This is what I could gather on the web, could someone shed some light as to whether this information is correct?
As I stated above, this is to verify that SQL is installed before my Wise Setup continues.

All versions:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

6.0 and above:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLExecutive

7.0 and above:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server 7
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServ65

Any help is appreciated. Thanks for your time!

 

[rmiley]

Have you checked out MS Technet article 321185 ?

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

Maybe this is what you are looking for.

Good Luck

 

[techkate]

Thanks for the link, rmiley but unfortunately that is not what I'm looking for.

You see, this .msi installation will search the registry to see if SQL is installed and what version/service pack. I will not actually be utilizing SQL to perform this check. I'm looking for specific registry values.