Also, do you have delay validation turned on?

If you search yahoo on your error you'll find plenty of discussions on it.

Maybe you'll find the answer there too.

Did you setup your package to log all errors, warning, etc. If so is there anything in there that would lead you in the right direction?

If that's...

Yeah, since you can't mirror system DBs you can copy all your jobs and SSIS packages, etc over to be ready in case it has to failover.

I actually wrote my own that I'll be putting on the market fairly soon.

I'm not entirely sure. Somewhere in the handshake the client tells sql which DB it wants to be in. You can try to test for the DB_ID() function,...

Did you give that acct specific rights to that type of action?

Check under sql server agent\proxies...

Maybe you're missing an OS perm... have you run this same thing from the...

It has to have a minimum of DTSOperator rights in msdb. And of course, whatever rights it needs to do what you're asking it to do. But DTSOperator...

If you go under the assumption that pretty much anything you can trace on you can get access to in tsql as well, your problem could have an elegant solution.

Try...

Not sure I've heard of this one before, but I'll throw a couple things out for you to check...

1. Perhaps explicitely give him 'backup log' in the DB properties.

2....

Well, you'll just look in the sysadmin group. If it's in there, you're good.

Also, any acct you want to use for a service has to have OS rights. ...

Go into the DB\security\schema and give them rights specifically in that schema. So you'll right-click on the dbo schema and go to properties... then give them whatever rights you...

Oh yeah... I forgot. You CAN add builtin\admins back in if you need.

All good questions:

1. I believe if you want to run the service under local, then you'd have to give sa to 'Local Service'. However, it's best to create...

The agent will verify the acct every time the job runs so if the acct is deleted in AD, then your job will fail until you change the acct.

My guess would be that the repl ID is what's stopping you. It sounds like it's looking to do something that that ID like either kill it or keep...