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

UCCX 7.0 custom reports.

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.

4 REPLIES
Hall of Fame Super Silver

Re: UCCX 7.0 custom reports.

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

Re: UCCX 7.0 custom reports.

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.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
Super Bronze

Re: UCCX 7.0 custom reports.

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Re: UCCX 7.0 custom reports.

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

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
1286
Views
0
Helpful
4
Replies
CreatePlease to create content