If the task wakes up the computer but gets stuck in the login screen use the group policy to add your username into this:
Computer Configuration-->Policies-->Windows Settings-->Security Settings-->Local Policies-->User Rights Assignment--> allow logon locally
Actually, the task does not need to be logged to work. Simply uncheck the task the option "run whether the user is logged or not". The task will just do whatever you will ask (exeg. play a sound usinggusing WMP) behind the logging screen. (If you really need to log on edit the group policies).