I kept receiving an error message in the event viewer about 2 of my SQL jobs and couldn't figure out why it was occurring. The error contained [SQLSTATE 42000] (Error 22029). After doing some research, I realized that's a very generic error message. All of my jobs were running as the system admin account and for some reason, still failed. What I didn't realize is that in SQL 2000, if the Domain\Administrator did not have permission to the master and database, it would not tell you so. This is not the case for SQL accounts where it simply states that the user does not have permission. For some odd reason, the Domain\Administrator was removed from the System Administrator role. I guess its a good thing it was only a test database. :)