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...
[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.
Any help would be appreciated. We are running 7.0 SR3.