thank's for the update

the application are isolated to each othere and they use maximum simillarer tabel and SP

but fee differnet tables also .

on passive node first u hv to unstall sql

then install sql and after that install add node to make both the server in cluster

the same account is use for all instance in same cluster and it working fine

but this is geting failed , we did the same but no good news

i tryied...

It is Enterprise edition

we using same account for services

Other instances on this cluster is active and working fine

onely one instances geting failed.

Once we restart SQl services manually it get...

i want to test the functions that these components support

yes , u can execute it !!

thank's to all for your valuable suggestion.

but still the problem is same .

as it due to domain access it not solving my problem .

is three any way by seeing...

good , but it will not help for findinding client

can we find some other alternative way as its not geting for all server

thank's for prompt response

i have 500 server and differnt version of SQl(2000,2005,2008) and have to

find SQL client or SQL server installed on these server...

Hi

thank's for reply

can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'

thank's to all for your valuable input .

but i need this below info

1) is all SQL server 2008 services like (reportaing , Analysis Services ) using differnt port...

Hi vishal and Balance,

thank's for your valuable inputs,

Vishal can you please describe more, how to do it .

Hi,

Is your databse recovery mode is Full, Pls chek it .