i would re apply SP2 in this case

Niyala (12/4/2008)

---

Thanks.

Because it would be much easier for me than adding individual members manually and, therefore, I wanted to import the Builtin\adminstrators.

Alternatively, I wanted to create a login for a...

its more to do with admin rights on the box, put yourself in the administrators group on the server and watch the little green arrows appear 😉

your welcome

why would you want to allow any windows server admin access to sql server as an admin?

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...