I have a problem with IPCC 4.5(2) and Historical Reporting client. I can not login.
First step is authentication and there is no problem, but the HR client can't open database connection to db_cra.
Here is the error from log file:
1: 5/22/2007 7:40:34 PM %CHC-LOG_SUBFAC-3-UNK:Unsupported Language detected with LCID=1026
2: 5/22/2007 7:40:49 PM %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'.)
3: 5/22/2007 7:40:49 PM %CHC-LOG_SUBFAC-3-UNK:Database Connection Error | Failed to login to database. Ask your administrator to check the database user id and password that is dynamically obtained from the application server.
4: 5/22/2007 7:40:50 PM %CHC-LOG_SUBFAC-3-UNK:CRA_DATABASE Connection String: Provider=MSDASQL;APP=Cisco CRA Historical Reports3960;Persist Security Info=False;Trusted_Connection=No;DRIVER=SQL Server;UID=db_cra;PWD=*****;SERVER=192.168.1.42\CRSSQL,4433;DATABASE=db_cra;NETWORK=dbmssocn;
5: 5/22/2007 7:40:50 PM %CHC-LOG_SUBFAC-3-UNK:Failed to login user to the apps server since we failed to initialize database connections
I think the database user have to be CiscoHistRprtUsr, but there is a negotiotion between HR client and database server and db_cra appears as DB user for DB connection.
If I change configuration in Config file at [CRA_DATABASE] section, then the HR client rewrite the config file back to original configuration:
My question is:
Can I use database user named db_cra for database connection and how to configure it at IPCC server? How to find the password for this user (log file says *****)?
I'm sorry for my english:)