Scheduled Task not working after sql2008 migration.
This is my first posting so here goes:
I have recently migrated SIMS from sql2005 to sql2008 and after doing so the scheduled task stopped working in SIMS. When I go to scheduled tasks and try to open any of them I get the following error message:
UnauthorizedAccessException: Access is denied. Fault Code: 1347-8174-1600 A .Net Framework error occured during execution of user-defined routine or aggregate "db_fnt_get_scheduled_tasks_all": System. UnauthorisedAccessException: Access is Denied(Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(see attachment for full message).
Has anybody else had this problem and if so how did you resolve it.