WFM QM Connection Error

[b.eman]

I am installing WFM 8.5.1 in a UCCX 8.5 enviorment.  Install seems to go fine but then I receive the error below.  I successfully created a test ODBC connection from WFM to QM server but can't get past this step.  My QM server is 172.16.220.40, the QM_user is the same user name I used for the test ODBC.  Any suggestions?

[b.eman]

Here is the test ODBC from the WFM server.

[octavian.dumitrescu]

Hi,

There is a SP_CreateQMView.sql script that runs and apparently fails.

To further troubleshoot the issue, I would run this script directly from WFM DB query and see where it fails.

Regards,

Octavian

[ausjustin]

i Had same issue , but still not resolved it yet .

Hi b.eman

have you resolved the issue yet ?\

[octavian.dumitrescu]

Do you have SQL 2008 server?

Because these SQL installation scripts such as the one above, fail under SQL 2008 because of certain syntax mismatch. I had to manually modify the SQL scripts and then run the setup again.