jorge_bittencou
9th November 2003 17:29 UTC

How to detect if ms sql server 2000 is installed
Hi there, does anyone know how to detect sql server on a machine? I´ve read the archives on how to detect if ... is installed, and I looked in the registry under HKLM Software\Microsoft\Microsoft SQL Server to do something similar, but I´m not too sure which field to test against.
There is one there, InstalledInstances, that I even tried to read from, but which instruction should I use to read from it? Neither ReadRegD nor ReadRegStr worked.

Thanks for any help in advance.

Jorge

kichik
9th November 2003 17:36 UTC

The instruction you need to use depends on the key's type. What does RegEdit report as the type?

jorge_bittencou
9th November 2003 19:28 UTC

It says it´s a REG_MULTI_SZ, which should be binary, I guess. At least if I try to modify the value in the registry, it says it´s binary.
Now I´ve searched the forum for how to read binary values from the registry and from what I understand, that´s not possible. So I guess I want to know if anyone knows any other registry key I can read that tells me whether ms sql is installed.
Thanks for the quick reply, kichik.

kichik
9th November 2003 19:50 UTC

REG_BINARY is binary... REG_MULTI_SZ is multi string. You should modify REG_MULTI_SZ Reader to your needs.

jorge_bittencou
9th November 2003 21:16 UTC

Thanks, man!

Jorge

icebrrrg
10th November 2003 19:35 UTC

I wrote some functionality to do this and posted it in the archives.

http://nsis.sourceforge.net/archive/...61&instances=0

(well I wrote it last week, but posted it today =)

-m-