How to detect SQL Server

ketchup84 · Post by **ketchup84** » Fri Sep 07, 2007 7:23 am

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 · Post by **natalia85** » Mon Sep 10, 2007 4:04 am

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 · Post by **Gizm0** » Mon Sep 10, 2007 7:28 pm

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.