Perry Whittle (9/2/2014)

Don't take this for granted, the server login and database user won't necessarily have matching names.

It's possible to have...

Here are the exact rights needed for the account that starts the agent: http://msdn.microsoft.com/en-us/library/ms178142.aspx

Other than that, you can start it with the System account or Network account, if...

Are you running the service with a useraccount, and if so, is it locked out?

This is how I do it, if anyone sees any mistakes I am making, please point them out. Of course, start with making a backup.

1. On the production server, run...

This site states that you need SP3 installed if you are using SQL2008 (not R2, which needs SP2)

http://msdn.microsoft.com/en-us/library/ms143393.aspx