The backup will not wake the computer to perform that action. You'll need to use Windows Task Scheduler to schedule some other task, perhaps as simple as opening Notepad.exe, to wake the PC from Sleep mode shortly before backup is scheduled to begin. It isn't a password issue if the drive is attached via USB, that is locally.
-steve