This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ankur_bhargava
Level 3
‎Oct 27, 2010 03:59 AM

SQL Server Prerequisite

Hi,

I want to add a prerequisite for SQL server in my setup. If any version of SQL server (greater or equal to SQL Express 2005) is installed on client PC then it would not prompt for installation otherwise it will install SQL express.

Please let me know how I could achieve this.

Thanks
Ankur Bhargava
Labels (1)
Labels
0 Kudos
(3) Replies
ankur_bhargava
Level 3
‎Oct 29, 2010 03:27 AM

experts please help me. I need this asap

Thanks
Ankur Bhargava
0 Kudos
MSIYER
Level 8
‎Oct 29, 2010 08:57 AM

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
This key should be present in the registry if SQL Server is installed. Try opening the regedit.exe and finding this key to learn more about it.

Use Installscript functions like RegDBKeyExist to query this key. Then, according to the return values, proceed with your install.
0 Kudos
ankur_bhargava
Level 3
‎Oct 29, 2010 09:24 AM

Hi MSIYER

thanks for reply.

I am creating MSI installer, please let me know how I achieve this in MSI installer.

Also, suppose machine has SQL 2000 installed on it, then I guess this key exists there too. but in this case I want to install SQL 2005 express.

Thanks
0 Kudos