check for this registry entries.

HKEY_LOCAL_MACHINES\SOFTWARE\microsift\MSSQLServer and Microsoft SQL Server.

Remove this before the developer instlation.

Hi All

Finaly this has been resolved. While the hardening og the server the sql service a\c SPN was broken.;). Thanks very much for all who gave their advices.:)

This is not a test cluster, a new build server, but can test anything at the moment.

Did someone rename a service account :No..but as part of server hardening some thing might have changed( reverted back the changes)

In that case, drop the login from sqlserver and add...

should be tcp\ip..

btw I have read some where this

The fact that in the error message you are getting Login Failed for user

(null) means that the Cluster service is trying to...

Yea I can start SQL services using net star, previously also I can manually start SQL service and agent service. And even cluster also doing this when I try to...

Double checked the cluster a\c..all resources except sql is online.

when a use net start instanceanme, getting error service name invalid.

Regards

Binu john

yeap..the same error in cluster.log ''Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connectionin cluster'.

The cluster account (svc-proxy-pclust)having sa rigths on SQL and they have reverted back the changes made( claiming?). Still when I start open the cluadmin the sql resources in 'online pending...

:hehe: Now the same thing happened again witht this error 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connectionin cluster'.

Today server guys has hardened the...

Yes..I did..understand where I went wrong..thx mate...

any thing found on sql error log or event viewer?

Can try to recover the db using dbcc dbrecover(msdb)

Good Article, looking forward to have next..

Thanks a lot,its working, last time we didnt selected the objects.