I got this error today too. I logged on as the service account and the default database for the service account was for a database that was deleted, so it had a logon error. I changed the default DB to master and everything worked.