Guys I had this error yesterday, which happened suddenly for a period of time, and then it vanquished!

the error

*************************************
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
*************************************

Any suggestions?



Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

__________________
Nothing is impossible. The impossible only takes longer. \"Digital Fortress, Dan Brown\"

click start,
click programs,
click Sql server,
click Configuration tools,
click sql server configuration management
on the left pane, Double click sqlserver 2005 services,
on the right pane, Double click Sql services select log on as: network services

Thanks a lot man, but I have sql server 2005 :s

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

ok i meant 2000 :)

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"