Thanks for you input guys. Okay I'm trying to understand in's and out's and found a very interesting exmaple as follows. This can explain you even better If you don't...

Gail and all others thanks for your input. I’ve notice something strange.When I've started SQL Server Services though Service. I witness SQL Server Status 'Started' within service however still when...

Not sure how to check Cluster Administrator logs. Can you please tell?

Thanks Gail for your input. Here is what I've found in errorlog. Open it with Notepad. You were right I’ve notice Service Broker start but then stop. And this is...

Thanks again Steve. I checked system log but it doesn’t help much. 4 information messages shows up

followed by 1 error message.

Information messages:

1.The SQL Server [SQLSERVERINS] service was successfully sent...

Steve and SilverFox thanks a lot for both of yours input. Yes there are 2 errors I've found in Application events log which are as follows.

1. [sqsrves]checkODBCConnection Error: sqlstate =...