Did you try restarting the SQL Server Agent service under control panel > administrative tools > services ?

Worked for me.

In case anyone else arrives here with the same original question I had - here's an update based on feedback here and in another forum:

Generally speaking, you can use either...

Thank you for the reply Lowell.

I was able to tally up the SQL in that script with Michael's instructions above. So much appreciated.

I've just hit a bump - not entirely...

Michael Valentine Jones (5/1/2013)

---

If you are on a domain, a normal way to handle this is to have the Web server service account connect to the database server.

1. Create a...

Thanks a lot - restarting the service worked for me. Still no idea why this happened, unless maybe I forgot to detach the database last time I opened SQL Server...