Prev: Debug without sysadmin rights?
Next: Help with Performance Issues / Application Event Log filled with S
From: Anjan on 7 Jul 2008 11:54
Hi! How to check that SQL Server 2005 Express is installed in a system?

I want to create a small program that will create or modify a specific
database for my software. How do i check for the existance of the sql
server? Then prompt the user if he wants to set up sql server express?

Thanks!

From: Ekrem Önsoy on 7 Jul 2008 13:11
Hello Anjan,

You can check the Keys under
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" to see if there
is an Express Edition installed or not.

Under that path, you'll see Keys such as "MSSQL.x" which stands for SQL
Server Component installations. And "Edition" values are kept under this
"MSSQL.x" Key's Setup Key. There, you'll see the "Edition" Value and it
contains the edition information of the installed SQL Server component.

And you may need to check the "FeatureList" Value to see if this MSSQL.x
belongs to a Database Engine, Analysis Services or Reporting Services.

I don't know if there is another more practical way.

--
Ekrem �nsoy



"Anjan" <anjan011(a)gmail.com> wrote in message
news:A735B253-95A2-486A-8814-E1226034AC97(a)microsoft.com...
> Hi! How to check that SQL Server 2005 Express is installed in a system?
>
> I want to create a small program that will create or modify a specific
> database for my software. How do i check for the existance of the sql
> server? Then prompt the user if he wants to set up sql server express?
>
> Thanks!

From: Uri Dimant on 8 Jul 2008 03:48
http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html




"Anjan" <anjan011(a)gmail.com> wrote in message
news:A735B253-95A2-486A-8814-E1226034AC97(a)microsoft.com...
> Hi! How to check that SQL Server 2005 Express is installed in a system?
>
> I want to create a small program that will create or modify a specific
> database for my software. How do i check for the existance of the sql
> server? Then prompt the user if he wants to set up sql server express?
>
> Thanks!


 | 
Pages: 1
Prev: Debug without sysadmin rights?
Next: Help with Performance Issues / Application Event Log filled with S