PowerFAIDS Integration (PFI) 9.2.3
In 9.2.3, PFI is moved from a stand-alone IIS site to the Web Administration sites (UI and Services). After upgrading, you may notice that user webadmin
, used by Web Administration Services, doesn't have enough rights to manage PFI SQL Agent Jobs.
To fix this, grant SELECT on sysjobs in msdb and add to SQLAgentUserRole:
USE msdb
GO
GRANT SELECT ON [sysjobs] TO [webadmin];
ALTER ROLE [SQLAgentUserRole] ADD MEMBER [webadmin];
Looking for the PowerFAIDS Integration access link under System Administrator > Tools > Setup? It's now named Web Administration.
No Comments