I believe there is a system error in Leopard's actions in regard to sleep.
Go into System Preferences, and select energy saver.
Then chose, to never let the computer sleep.
This seems like it won't be resolved until Apple posts another upgrade to Leopard.