Environment:windows2003 sp1
SQl server 2000, sp2, and It is clustered(2 nodes)
I need to uninstall  SQL server2000 . When i tried to uninstall from setup,
i have got error and so i have deleted manually so sql binaries and registry

As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.
I am still  getting Getting "Cannot delet MSsqlserver: Error while deleting

We have 2 node sql failover cluster configuration ( Server 2003 +SP2,
MSSQL2000 )
We can succesfully query the data from other MSSQL  Server over a linked
Server.

We have a single instance cluster on 2 nodes say SQL1. We want to do a
side-by-side upgrade of the underlying hardware and we have another cluster
with 2 nodes already ready and its called SQL2. At the time of cutover, we
want to just rename SQL1 to SQLOld and SQL2 back to SQL1 ...

we are having SQL 2000 for Sharepoint, wss and .net applications in Cluster
(Active / passive mode)
but we feel that it slow, is it anyway to do the fine tunning?
Thanks and Regards

I am trying to see if named pipes connection works on my cluster, sql server
2K.
I have tryied the 2 utilities, makepipe and readpipe.
The connection works if, when using readpipe, I use the physical server name.

I have a 2 node cluster active/passive 2003 SP2 cluster.
I have 4 instances
  SQLSRVISPS1\SQLSRV1
  SQLSRVISPS2\SQLSRV2

I am running in a cluster setup (this is working ok).
I cannot get the mssqlserver service to start.
Here is the error log...
2007-12-19 10:41:38.50 server    Microsoft SQL Server  2000 - 8.00.2040

Hello, everyone.
I installed a 2-node SQL 2005 Standard Edition with SP2 cluster
(active/passive).
I realized that the Management Studio was not installed on the 2nd node.

An installation of sql2k5 sp2 to one node of a three node
active/active/active cluster has failed.  It cannot proceed beyond the
beginning of the sql2k5 sp2 installation.  It fails because it can't install
sqlsupport.msi.  It seems to want to put the files in the wrong place.

I have a two node active/passive windows 2003 SP2 cluster.
I have three cluster groups created. One with MSDTC, the other with SQL
Server 2000 (I only have one instance) and the third with some other
resources like file shares.

I have a cluster sql server 2005 with 2 nodes. Now My users going to log to
SSMS with the console installed in the theirs console and ask me to disable
Management Studio in the cluster.
It's right this?

S it possible to set up SQL cluster like MNS, without having common share
drives ? or without vendor specific solution.
Target is to have high-availability, but have no SAN or share SCSI drives
available.

On a stand alone server, our naming convention for multiple instances is:
server         (default instance)  
server\IN1   (first named instance)
server\IN2   (second named instance)

I have a statement in the sp which does something like this.
@sql = 'SELECT OrderDate,CustID,Total,Balance from '
+ @Remoteserver
+ '.dbo.Sales.Orders where orderid =' + @orderid