I haven't seen it before, but I'm guessing that the Service Pack puts the databases in single user mode 'behind the scenes'. That way it can upgrade without being interfered with by user actions. You just happened to have problems during the short time it was in that mode.

I'm also guessing, but I think you would have been able to log back in with the SA login and password.

-SQLBill