How can i determine that sql server 2005 express is installed in a system?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anjan - 07 Jul 2008 16:54 GMT

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!

Reply to this Message

Ekrem Önsoy - 07 Jul 2008 18:11 GMT

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.

Signature

Ekrem Önsoy

> Hi! How to check that SQL Server 2005 Express is installed in a system?
>
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message

Uri Dimant - 08 Jul 2008 08:48 GMT

http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html

> Hi! How to check that SQL Server 2005 Express is installed in a system?
>
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message