Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Historical Reporting login error

Hi experts,

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:

[CRA_DATABASE]

DRIVER=SQL Server

SERVER=192.168.1.42\CRSSQL

DATABASE=db_cra

AUTH=2

UID=db_cra

NETWORK=dbmssocn

PORT=4433

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:)

Thank you

5 REPLIES
Silver

Re: Historical Reporting login error

the language of your Operating System is what is preventing the HRC from running properly. The supported languages are

English

French

German

Italian

Spanish

Simplified Chinese

Japanese

Please change your OS language to one of these, and then uninstall and reinstall the Historical Reporting client.

New Member

Re: Historical Reporting login error

Hi

wwe have the same problem.

we also tried to change the language, but it did nor work.

does anybody have any clue of what the problem is ?

regards

Tore

New Member

Re: Historical Reporting login error

Hi,

I had problem to log into Hist Report client because the proxy in IE was set (XP sp2).

regards

Re: Historical Reporting login error

I ran into the same error after changing the SQL authentication method from Windows Only to Mixed Mode.

I resolved the issue by changing the Auth parameter from blank to 1 in the hrcConfig.ini file on each client.

Here is an extract from that file:

;AUTH specifies the authentication mode to use while connecting to the database.

;Use one of the following values:

;1 - Windows NT Authentication

;2 - Mixed Mode Authentication

AUTH=1

New Member

Re: Historical Reporting login error

You're great! You saved my life! ;-)

I run into the same problem and the configuration of the authentication mode did the trick.

Thanks a lot!

Joachim

1053
Views
30
Helpful
5
Replies
CreatePlease to create content