Re: How do i discover SQL server is running ...

Checking the registry would only tell you that SQL Server has been
installed -it wouldn't tell you IF it is running, or incompletely removed,
etc.

Asking SQL directly would require that you knew the SQL Server
name -normally the same as the host, but not necessarily.

Checking the services for 'Started' (or not) could work.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



<thirumalaivelu@xxxxxxxxx> wrote in message
news:1152253106.670394.42180@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello ,

I'm trying to create an application, which would say if sql server is
running on a machine.

Hope i can get this from windows registry. Is there any other way do
achieve this programatically through windows SDK , or checking the
services programatically ?
If i need to check the registry what are the fields that i should look
at ?

thanks in advance,
Velu



.

Relevant Pages

  • Re: fulltext search not working
    ... MSSearch service components or registry key &/or values at the server level ... with Microsoft SQL Server support. ... > the FTS component as the server is a production database and is hosted on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... See following article which contains information about Registry and editing ... Stop all services of virtual SQL Server by cluster administrator. ... On NODE1 change value of Key ... Start all services of virtual SQL Server by cluster administrator. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Performance Objects (sqlctr80.dll)
    ... reasons, such as Permission, Server Crash, Registry Modification and Virus. ... and "First Counter" values can vary between SQL Server ... Unload the SQL Server Counters ... In command line, execute "unlodctr MSSQLServer" (Without quotation, the ...
    (microsoft.public.sqlserver.setup)
  • Re: Failure to Login
    ... I had already checked the Registry ... At a command prompt, if I ... the MSDE was install with OS Authentication. ... >is the default setup for the SQL Server 2000 Data Engine.) ...
    (microsoft.public.sqlserver.msde)
  • Re: fulltext search not working
    ... this is a FTS component or registry ... as this problem is at the SQL Server level and not database specific. ... and stop both the MSSQLServer and the MSSearch services. ...
    (microsoft.public.sqlserver.fulltext)
Loading