cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2716
Views
9
Helpful
16
Replies

Custom Reports - connection to UCCX 7.0 database fails

gsidhu
Level 3
Level 3

Hi,

Let me start off by saying that I have very limited knowledge on SQL.

This is for a two node UCCX Ver 7.0 cluster (hence SQL database).

Customer wants to create customized reports but is unable to pull data from the SQL database - please refer to attachments (you will see a screenshot showing connection failure). Different Login ID and passwords have been attempted.

Please could somebody tell me what the credentials are for accessing data from the UCCX database.

I would also appreciate any information on what the procedure is for accessing data from the SQL database.

Many Thanks

16 Replies 16

Jonathan Schulenberg
Hall of Fame
Hall of Fame

Direct ODBC connections are not supported. The supported path for custom reports is to write new Crystal XI reports and integrate them into the existing Historical Reporting Client. This involves new stored procedures within the db_cra SQL database on CCX and/or changes to the XML and RPT files on the HRC workstation. Note that any custom report files created cannot be rolled into the HRC installer and must be propagated to HRC user workstations (and backed up) manually.

Historical Reports User Guide for Cisco Unified CCX and Cisco Unified IP IVR, Release 7.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/user/guide/uccx701HR_English.pdf

Database Schema Guide for Cisco Unified CCX and Cisco Unified IP IVR, Release 7.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/user/guide/uccx70dbschema.pdf

Historical Reporting Administrator and Developer Guide for Cisco Unified CCX and Cisco Unified IP IVR, Release 7.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/programming/guide/uccx70hradmdev.pdf

Also, there was a session at Cisco Live 2009 on CCX custom reporting and future road map plans. One of the developers presented and provided a good orientation. The same orientation to custom reporting is also supposedly posted to PEC (if you are a partner); however, I haven't seen this VoD myself.

P.S. Don't bother getting around the ODBC restrictions. Version 8.0 (due out Q1CY10) will be a sealed Linux appliance identical to UCM. Don't waste your time writing something that puts the customer into an unsupported state.

sovannary.huy
Level 1
Level 1

Hi,

Did you try to connect from client computer? If so, please make sure that client computer and CRS server use the same Administrator password.

"Also, there was a session at Cisco Live 2009 on CCX custom reporting and future road map plans. One of the developers presented and provided a good orientation. The same orientation to custom reporting is also supposedly posted to PEC (if you are a partner); however, I haven't seen this VoD myself"

j.schulenberg, do you have the link for this?

sovannary.huy,

Must the client computer login (into Windows) using the same Administrator username and password as the UCCX server? Any better way of doing this? I'm assuming port 1433 must also be opened between UCCX server and client computer.

Thanks!

-JT-

Must the client computer login (into Windows) using the same Administrator username and password as the UCCX server? Any better way of doing this? I'm assuming port 1433 must also be opened between UCCX server and client computer.

Answer is no, you would login with your Windows account on the PC. You would login to HRC with the credentials that are created in UCCX. Be sure that the user has the reporting capability added.

hi joesnyde,

Thanks for your response. The issue I'm facing is not related to HRC access which is understood that existing uccx user (with reporting capabilites) is able to login.

The issue is related to creating custom report using Crystal in the same client pc having HRC. I wouldn't be able to create odbc connection as the uccx user is neither a uccx database user (Security->Logins) nor a uccx server user (Computer Management -> Users).

The only workable solution currently is to have the same administrator username/password in both client pc and uccx server (as well as logging into client pc using administrator credentials).

Thanks!

-JT-

What about adding that user to the local admin account? Or adding that user as part of the Domain Admin group? Is this a possiblity?

A video for creating custom reports can be found on PEC.

Go to "Advanced" search. Select the packages tab and type in CCX Ignite and it will return 4 packages. Under CCX Ignite - Support there is a course on creating custom reports.

Hi gsidu

Hope all is fine at your side.

Can you tell me please if you were able to reach anything regarding the SQL access??

I am facing the same problem now and if you can give me a solution that would be really great. I have been searching on tne net for about a week now but with no clue.

Appreciate your assistance please, thanks a lot.

Can you describe what you are trying to do?

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

Hi,

My issue did not get resolved and I haven't taken any action since my last post

Hi

See my post on this issue.

https://www.myciscocommunity.com/message/34036#34036

To get SQL access to the SQL server on UCCX if running in Windows Auth mode from a domain workstation, you need to create a local account on the UCCX box with the same username and current password as your domain account. You then grant that local account access to SQL.

Regards

Aaron

Please rate helpful posts...

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

Hi Aron,

Many thanks for your post, but can you help me please with the following:

1. How can I grant that user access to the SQL database?

2. Will I need the CRSAdministrator account to give him that access? Long story short the password is not available.

3. If I will need the CRSAdministrator password, is it OK to change it through the UCCX Admin Utility? We have one UCCX server only so I guess it will not cause a problem, but I am afraid changing it will ruin anything else.

Sorry for all these questions but I am not an experienced in SQL that much, thanks in advance.

Regards

Hi

To grant permissions to the DB, you need a local administrator account on the UCCX server (not an application administrator/ccm user).

A quick way is to grant add user you create on the UCCX to the local administrator group in Computer Management/Users - any local admin gets SA rights to the SQL server.

Otherwise:

Steps:

Go into SQL Enterprise Manager in start/programs/Microsoft SQL server.

Click on the 'localserver' or your UCCX server name under Microsoft SQL Servers

Expand the 'Security' item

Click 'Logins'

On the right, right click and hit 'New Login'

You should be able to select the user by clicking a ... button or enter it in the username box in servername\username format. If you do this right, password should be greyed out as it will use the windows password

Set the default database to db_cra

Click on the Database access tab, and then click db_cra in the top box.

Tick the 'Db_owner' role in the bottom box

Hit OK.

Regards

Aaron

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

Hi Aaron,

Thank you very much for your help, will try that and feed you back with the results.

Regards

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: