thanks for very much for your reply Seth. I agree with you I also like to reboot after installing services, SPs etc and I can always fail each node over...

yes you are right but the problem I had which i was able to fix was 2 things actually;

1. we got hit with the conficker virus and followed MS intructions...

thanks everyone for your posts I can see my drives now. I added dependicies to the sql server , sql agent and full text services in other resources and now...

hi thanks for the quick response i just checked and no there not so that is what I will do next. thanks for your post

yes as a matter of fact I ended up working this out for myself. I had logged the fault with MS which was going onto its third department in the...

MS phoned me back on Friday and I got them connected to my server for over an hour.... still no resloution yet. I have sent him sql and app log...

i can try that but i still cannot connect via SSMS as even though the services are started in services.msc they are not started in SQL SCM which is where...

that is the problem in itself, i cannot get the services to start in SQL, i can get them started in services.msc but i get the same error when i...

when I try an add NT AUTHORITY\SYSTEM to the sysadmin role in sql server user provisioning i get the error:

a network-related or instance-specific error occured while establishing a connection...

re: Have you removed BUILTIN\Administrators from SQL Server?

If you have, you will need to add NT AUTHORITY\SYSTEM as a 'sysadmin' to SQL Server.

I have not done this, i will...

sorry just got your edited post ignore my reply

here is one link: http://technet.microsoft.com/en-us/magazine/cc672627.aspx

about half way down the page:

Enhanced Security Features

Failover Clusters feature several new security enhancements. Perhaps the most significant involves the removal of...

Hi Ian, Windows 2008 Cluster uses local system account to run the cluster service. It is recommended that you use this account on the cluster service, I have tried changing...

But I can't help thinking, why was the cluster working fine before I put the patch on?

thanks for your post happycat59, this is a brand new fresh install of W2k8 and sql 2005 and until I'm happy with the cluster i will not hand it over...