my changes are in red, put single quotes around the logical filenames like...

the empty white circles mean you can connect to sql server but you don't have rights to stop,start, restart the windows service(s) for that instance

clusters are either active\passive or active\active regardless of the number of nodes.

do you really need 50 instances? Remember that when a node fails the resources will be resumed on another...

i take it that means you havent changed the account, could anybody else have access to do this?

have you changed the account sql service runs under by any chance?

clustering does not provide load balancing only fail over.

what is it you are looking to do specifically

this only applies to sql 64bit, its ok under 32bit

for corporate there will be an anuual licence cost, it wont be as high as the intial purchase but still needs to be paid.

RAID 5 will only tolerate 1 disk failure at any time even if there are 3 spares. RAID 50 does allow multiple failures AFAIK but RAID 10 is a better...

smunson (12/3/2008)

---

Thanks Gail. If you could, though, can you at least point me to the other posts about what priveleges one should be granting the accounts to be...

recommend they bin VSS and get Subversion instead 😉

it sounds very much like there are foreign keys and they are missing column information.

i would query the system views and find out which foreign keys are affected. Drop them...

RAID 10 if you can RAID 5 if you want to keep it simple, RAID 0+1 involves mirroring over a striped set and is not as tolerant as RAID 10

the 80 folder contains numerous backward compatability components

to get a list of database and filenames use

select name, fileid, filename from sys.sysaltfiles