did this with ssrs 2008 R2.

kinda works, jobs do not create (msdb has changed some). manual fail-over steps on same old keys.

have to do good old

C:\Users\sqlinstalladmin>rskeymgmt -l

QASQL2008M\MSSQLSERVER - 87d8f5f3-ca94-4a81-94c4-5f477ee03cd6

QASQL2008\MSSQLSERVER -...

it misses schema permissions

SELECTCASE WHEN perm.state <> 'W' THEN perm.state_desc ELSE 'GRANT' END

+ SPACE(1) + perm.permission_name + SPACE(1)

+ SPACE(1) + 'ON SCHEMA ::['+sc.name +']'+ SPACE(1)

+ SPACE(1) + 'TO' + SPACE(1)...

you mean?

Elliott W (11/23/2009)

---

account that is a member of the sysadmin fixed server role in...

so do I :). job is owned by sa.

Joie Andrew (11/23/2009)

---

By default the agent job runs under the account that created the job, not the agent account. If you go into the properties of the job, does it...