In CRS 3.5, the CRA historical report client computer is unable to connect to the CRA server, and the historical reports client log file shows "the Not associated with a trusted connection" error message

[TCC_2]

Core Issue

The Structured Query Language (SQL) server is not accessed with the proper authentication.

Resolution

To resolve this issue, perform these steps on the Customer Response Applications (CRA) historical reporting client computer:

1. Go to Start > Programs > Microsoft SQL Server n > Enterprise Manager, where n is a version number. 
2. Double-click Microsoft SQL Servers. 
3. Double-click the SQL Server Group. 
4. From the SQL server group, right-click the name of the server on which the CRA databases reside. 
5. Select Properties. 
6. Select the Security tab. 
7. Click the SQL Server and Windows NT radio button. 
8. Click OK.

For more information about resolving Cisco CRA and Customer Response Solutions (CRS), refer to these documents:

• Diagnosing and Correcting Cisco CRA Problems 
• Cisco IPCC Error Codes

Problem Type

Voice applications  (CRS, PA, CCM Plugins, CER, CCC, MeetingPlace, etc.)

Failure Type

Cannot connect to server, disconnect, register, synchronize, communicate, etc.

Error message

Voice Application Errors

Not associated with a trusted connection

Customer Response Solution (CRS) Version

CRS 3.5

Customer Response Solution (CRS) Applications

IP Contact Center (IPCC) Express (formerly IP ICD)

Customer Response Solutions (CRS) Components

CRA server

Customer Response Solutions (CRS) Reporting

CRA historical data

Voice Applications

IP contact center (IPCC) express