Clustering on sql server workgroup to domain

[timscronin]

We have a set of client servers which will include a SQL Server 2000 active/passive cluster attached to a SAN. We have all the equipment here (no attachment to client site) to configure. My worry is since it will have to be setup as a workgroup, and then shipped to client to add to their domain, is this a doable option. has anyone had to do this or tried this? Or would we be better off shipping whole thing to client and setting up cluster there?

 

[mrdenny]

Ship it off and cluster it there.

When setting up a cluster you must have a domain account to setup the cluster monitoring. You also only get one shot at installing SQL on the cluster. If you don't like something you have to manually remove SQL from the cluster (there is no uninstall on a cluster) and try again. We found that it was easier to simply format and start over.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief