I'm trying to understand what method (i'm assuming SQL query) and credentials is OCC Service in WFM is using when connecting to UCCX db (for automated 30 minutes historical data extraction). There's a couple of system DSN created during install (acdDbMain, acdDbBackup) which has been setup for NT authentication.
There's no requirement during installation/config to create NT/SQL user on UCCX/both server to allow this access. The error i'm getting is relatively generic sql error 18452 login failed for user "null" in the ooc logs. I'm getting the same error when OOC process (for old historical data capture) manually.
I'm currently running wfm833 and uccx701sr5 (db in windows authentication mode)
Any ideas? Thanks!