I'm glad you resolved this problem.

>>Is it server or workstation? What WIndows version it's running?
>
>thanks sergey for replying. appreciate it.
>
>it is on a win2k advanced server.
>but the solution has been found.
>
>it is because the Windows Login password was changed without first changing the SQLServer password authentication to similar one.
>
>when on reboot, the SQLSERVER will not run. Now it is working fine.
>We were without the SQL Database for 3 days. It is a lesson learned. :)
>