Showing posts with label checking. Show all posts
Showing posts with label checking. Show all posts

Wednesday, March 7, 2012

Registry For Cluster

What is the registry path for checking if there is a SQLServer installed as a
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to know all the names of SQL
that could be a default instance on virtual server or a named instance.
It is a windows 2003 in sql 2000 environment.
Any help will be appreciated.
-Nitin
What a terrible newsgroup it is. Not even people from MS respond to the
request hanging for over 2 days
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
|||Personally, I would not interrogate the registry to find whether there is any
clustered SQL instance. rather, I'd just use Cluster Automation Server (CAS)
via a script. See this article
http://support.microsoft.com/default...B;en-us;244597
for an example on how to script with CAS.
Linchi
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin