I am attempting to setup an ODBC connection to the Historical Reporting table of the UCCX 7 database so we may generate some custom reports for weekly meetings and show better call metrics which the call center staff is bonused on. However, I am running into an issue where it doesn't seem to authenticate me properly, I get the following results when I test the connection:
Microsoft SQL Server ODBC Driver Version 06.01.7600
Running connectivity tests...
Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'CRSAdministrator'. Reason: Not associated with a trusted SQL Server connection.
I am going through the steps on page 6-2 from the PDF below found on the Cisco site.
Why use CRSAdministrator? In order for that to work from anywhere but the UCCX box, you'd have to have something running in the context of a user with the same name and same password...
You basically need to be able to authenticate to the SQL server using the account you are logged in as on your dev workstation (or under the account that your web site/whatever service runs under).
To do this, you need to create a local account on the UCCX server, with the SAME username and SAME password as your service/user account on the domain or your app server. Grant that local account the required DB permissions, and windows will basically pass through the auth and all will be well.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...