It took over five hours, but Microsoft now says that Xbox Live should be back up and running in North America.
If you can't connect, try the console reboot sequence described here first. And if that still won't let you sign in, let us know in the comments below!