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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Bronze

Historical Report Tool in mixed mode authentication

When I switch CRSSQL from Windows authentication to Mixed Mode authentication, users cannot log in Historical Reports Tools any more. It returns error:

"Failed to login database. Ask your administrator to check the database user id and password that is dynamically obtain from application"

Is there a way to make it works in mixed mode?

CCX is running with CRS 5.0 (IPCC Express)

Thanks,

Dat Pham

6 REPLIES
Silver

Re: Historical Report Tool in mixed mode authentication

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.

Bronze

Re: Historical Report Tool in mixed mode authentication

Thanks ivillegas,

I will check on that.

DP

New Member

Re: Historical Report Tool in mixed mode authentication

just an update... i spoke with TAC and they claim that is caused by changing the autentication to mixed mode... they ask me to change it back (will do it today) and to hope that it will fix the issue...

New Member

Re: Historical Report Tool in mixed mode authentication

Hello.

I have the exact same problem, i checked both settings as mention below and they all as should been (25 licenses in the application and access in the db).

any other ideas ?

Re: Historical Report Tool in mixed mode authentication

Here is the Admin guide pointer which mentions IPCC DB should be running in "windows authentication" mode.(page 210)

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_5_0/maintenance/admin/crs501ag.pdf

It says clearly , "Cisco CRS does not support the use of Mixed Mode authentication for internal SQL with MSDE or SQL 2000."

New Member

Re: Historical Report Tool in mixed mode authentication

thank you. this is helpful.

624
Views
10
Helpful
6
Replies