How to detect SQL Server

[ketchup84]

How can we detect if user has installed any SQL Server 2005 or SQL Server 2005 Express? And if not SQL Server 2005 Express is installing.

[natalia85]

I have the same problem. User have installed SQL Server 2005 , when the instalation process starts, instalator wants to install SQL Server Express- for what? ;/

I don't know how to overcome this problem- I don't know what to do to detect SQL Server 2005
My aim: if SQL Server is detected, SQL Server Express won't install

Any ideas what should i do ?

[Gizm0]

Hello,

All you need to do, is to check if HKEY_LOCAL_MACHINE/Software/Microsoft/Microsoft Sql Server/ key exists. If it does, a version of Microsoft Sql Server is installed. To Check if 2005 is installed, you need to check for HKEY_LOCAL_MACHINE/Software/Microsoft/Microsoft Sql Server/90 Key. If exists, then SQL Server 2005 is installed OR a version of SQL Server 2005 Express.