Historical reports error

[satishy_2]

I have upgraded my server from IPCC 4.0(4) TO ipcc 4.0(5) HA.

Currently only primary server is up , secondary server is down.

When I login to historical reports that system gives the error message " Can not connect to database.. see lof files..

the log is as below.

8/27/2007 9:55:06 AM %CHC-LOG_SUBFAC-3-UNK:CRA_DATABASE Connection String: Provider=MSDASQL;APP=Cisco CRA Historical Reports1012;Persist Security Info=False;Trusted_Connection=Yes;DRIVER=SQL Server;SERVER=X.X.X.X

\CRSSQL,4433;DATABASE=db_cra;NETWORK=dbmssocn;

4: 8/27/2007 9:55:06 AM %CHC-LOG_SUBFAC-3-UNK:Failed to login user to the apps server since we failed to initialize database connections

1: 8/27/2007 12:55:12 PM %CHC-LOG_SUBFAC-3-UNK:Database connection to 'CRA_DATABASE' failed due to ([Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'db_cra'. Login fails.)

2: 8/27/2007 12:55:13 PM %CHC-LOG_SUBFAC-3-UNK:Database Connection Error | Unable to establish connection to database. Check the log file for error 5051.

3: 8/27/2007 12:55:19 PM %CHC-LOG_SUBFAC-3-UNK:CRA_DATABASE Connection String: Provider=MSDASQL;APP=Cisco CRA Historical Reports3568;Persist Security Info=False;Trusted_Connection=Yes;DRIVER=SQL Server;SERVER=X.X.X.X

\CRSSQL,4433;DATABASE=db_cra;NETWORK=dbmssocn;

4: 8/27/2007 12:55:19 PM %CHC-LOG_SUBFAC-3-UNK:Failed to login user to the apps server since we failed to initialize database connections

[pradeepde]

To resolve this issue, perform the following:

1)Historical Reporting uses only Windows Only Authentication mode, so if you are using the Mixed Authentication Mode, you need to change the Authentication mode to Windows only.

2) On the Historical Reporting Client PC, create a DSN that points to db_cra.