UCCX 7.0 custom reports.

Unanswered Question
Nov 26th, 2009
User Badges:

Hi,

We have UCCX 7.0 SR4. We have installed SQL 2k on UCCX machine. We have configured mixed mode authentication. We have created an user (name: test) and provided permissions to access CRS databases.


I am trying to login to the Historical Reporting Client (HRC) using the SQL user. But i am getting the following error     .


"An error occured while attempting to communicate with web server.Check your user id and password and try again"



Can i login to Historical Reporting Client and generate reports using the user which i created in the SQL server?


Please help me on this.


Regards,

Gokila.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Chris Deren Thu, 11/26/2009 - 07:28
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,
  • Cisco Designated VIP,

    2017 IP Telephony, Contact Center, Unified Communications

There is a bug for this issue when you change authentication to mixed mode, Try this:


Change the AUTH parameter in hrcConfig.ini on the historical report client PC:


BEFORE:

;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=


AFTER:

;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=2

HTH, please rate helpful posts!
Chris
Anthony Holloway Tue, 06/08/2010 - 15:58
User Badges:
  • Purple, 4500 points or more

I just came across this looking for an answer myself.  Chris has it wrong, it should be:


AUTH=1


Which is counter intuitive to what it looks like it should be, but it works, and is posted in the UCCX 7.0(1) SR5 release notes.

Aaron Harrison Wed, 06/09/2010 - 02:15
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


Yeah, also there are two AUTH params; the first one is in a section that gets updated dynamically when you log in, and the second on is the one you need to change.


(I think).


Aaron

Anthony Holloway Wed, 06/09/2010 - 11:50
User Badges:
  • Purple, 4500 points or more

You are correct.  So it looks like this:



;Use this key to specify alternative values to connect to Cisco CRA database instead of using the default values

[CRA_DATABASE_ALTERNATIVE]

DRIVER=SQL Server

SERVER=10.0.101.13\CRSSQL

DATABASE=db_cra

PORT=4433


;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


;NETWORK specifies the network library to use while connecting to the database.

;Example of values for NETWORK library:

;dbnmpntw - Win32 Named Pipes

;dbmssocn - Win32 Winsock TCP/IP

NETWORK=dbmssocn

Actions

This Discussion