WFM Server error

[G3n35Y5]

Hi,

I have installed WFM 8. When WFM Server service is started I see the following errors in the log:

************************************
12/15/10 15:43:13.609  CFSLCache: Cache loaded successfully.
15:43:13.609 Trc 20001 Genesys WFM Server  Version: 8.0.001.03  Compiled: Sep 20 2010 13:33:54
Copyright (c) 1999-2004 by Genesys Telecommunications Laboratories, Inc. All Rights Reserved.

12/15/10 15:43:13.609  Initializing...
12/15/10 15:43:13.687  Config Cache Preload -- Start (Cache Size: 0Kb, Target Size: 20Mb, Thread: 5132)
15:43:13.734 Std 20000 Could not open database Provider=SQLOLEDB;Data Source=SRVABC;Initial Catalog=WFM_DB;User ID=sa; reason  -- ; error code -2147221164  (Thread: 5132)
12/15/10 15:43:13.734  Config Cache Preload -- End (Cache Size: 0Kb, Thread: 5132)
12/15/10 15:43:13.859  Schedule Cache Preload -- Start (Cache Size: 0Kb, Target Size: 20Mb, Thread: 4924)
15:43:13.859 Std 20000 Could not open database Provider=SQLOLEDB;Data Source=SRVABC;Initial Catalog=WFM_DB;User ID=sa; reason  -- ; error code -2147221164  (Thread: 4924)
12/15/10 15:43:13.859  Schedule Cache Preload -- End (Cache Size: 0Kb, Thread: 4924)
15:43:13.859 Trc 04003 WFM_SERVER main process started
15:43:13.859 Std 04525 Port 6210 opened for listening
************************************

Troubleshooting actions:
I had set auto_close to off for the database.

alter database WorkForceManagement set auto_close off;

I am using SQL Server 2000. I tried using another database as well but I am still facing the same issue. Can anyone please help me resolve the same?

Thanks,
Genesys_user

[bandorka]

Hi,

Try to register oledb32.dll with regsvr.exe

Bandorka

[G3n35Y5]

I registered oledb32.dll using regsvr.exe successfully but I still see the same error in logs.

[René]

Hi,

Microsoft SQL Server 2000 is no longer supported by Microsoft so I would say that Genesys didn't test compatibility of WFM Server 8 and MSSQL 2000.

Are you able connect to SQL Server from other application (ODBC Data Sources Administrator, some script etc.)?

R.