Skip to main content

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.