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 Reports client + database error

Hi all,

I have installed the HR client on a PC in a new CC I just setup,the login step succeeds,or so I believe because I have created this HR user and given the rights,I've also made sure the security policy on the client PC is same as the CRS server.

When I try to login i get a DATABASE CONNECTION ERROR with the message

"Failed to login to database. Ask your Administrator to check the database user id and password that is dynamically obtained from the application server."

The system by default tries to use dba_cra as UID,which I don't see it as a valid user in SQL enterprise manager.

I would have set this up manually but I have no idea what password the HR client is sending to the CRA database.

Attached is a screenshot of the error.

Can anyone help?

Sleen

2 REPLIES
Silver

Re: Historical Reports client + database error

On CRS - check historical reporting session license is not set to zero

SYSTEM --> System Parameters --> Number of HR session licenses

CRS SQL

Go to SECURITY --> "xxxx\CiscoHistRprtUsr" and right click to Properties then go to "Database Access" tab, click on dba_cra

Check if the db_owner and public checkbox is ticked.

New Member

Re: Historical Reports client + database error

Hi all,

I had figured out the prob.It was the SQL MIXED MODE authentication I had selected.CRS doesn't support internal mixed mode authentication so I changed to NT Login only.

Thanks,

Sleen

346
Views
0
Helpful
2
Replies