[cisco-voip] UCCX historical report: DB access

[rj.e at gmx.de]

After changing SQL Server to allow both SQL Authentication and Win NT Authentication, I cannot login anymore to UCCX Historical Reports application. 

Log file (*_CiscoAppReports0.log) says:
1: 17.02.2009 17:38:12 %CHC-LOG_SUBFAC-3-UNK:Database connection to 'CRA_DATABASE' failed due to ([Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'db_cra'.)
2: 17.02.2009 17:38:12 %CHC-LOG_SUBFAC-3-UNK:Datenbankverbindungsfehler | Die Anmeldung bei der Datenbank ist fehlgeschlagen. Bitten Sie den Administrator, die ID und das Kennwort des Datenbankbenutzers, die dynamisch vom Unified CCX-Server abgerufen werden, zu überprüfen.
3: 17.02.2009 17:38:13 %CHC-LOG_SUBFAC-3-UNK:CRA_DATABASE Connection String: Provider=MSDASQL;APP=Cisco CRA Historical Reports3892;Persist Security Info=False;Trusted_Connection=No;DRIVER=SQL Server;UID=db_cra;PWD=*****;SERVER=10.178.209.197\CRSSQL,4433;DATABASE=db_cra;NETWORK=dbmssocn;
4: 17.02.2009 17:38:13 %CHC-LOG_SUBFAC-3-UNK:Failed to login user to the apps server since we failed to initialize database connections


I created also a new System-DSN (db_cra1) in ODBC Admin (test was OK) and added that to hrcConfig.ini:

[CRA_DATABASE]
DRIVER=SQL Server
SERVER=10.178.209.196\CRSSQL
DATABASE=db_cra1
AUTH=2
NETWORK=dbmssocn
PORT=4433
UID=db_cra1

But does not help, still same message (concerning db_cra and 10.178.209.197\CRSSQL  instead of db_cra1 and 10.178.209.196\CRSSQL !?)

I'm a bit confused what settings are taken for DB access? Any ideas?

Reinhold


-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01