Cisco Cisco IP Contact Center Release 4.6.2 Troubleshooting Guide

 

6 

 

Troubleshooting Guide for Cisco Unified Contact Center Management Portal Release 8.0(1) 

1.  Create a shortcut on the desktop of the Web Application Server 

with the file extension .udl. 

2.  Double-click the link to open the Data Link Properties window.  

3.  On the Provider tab, select OLE for SQL Server. 

4.  On the Connection tab, enter the necessary details to connect to 

SQL Server. 

Common error messages include: 

Login Failed/Access Denied The user name or password are incorrect / do 
not have access to the SQL Server. 

SQL Server is unavailable or does not exist The client was unable to 
access SQL Server over the network. Possible causes include: 
ƒ  Broken NW connection 
ƒ  DNS resolution failure 
ƒ  SQL Server Service or System down 

All error codes presented through this interface are standard SQL Server 
messages. 

Use the SQL Server Management Studio to sign in to the Admin 
Workstation from the Database Server using SQL Server authentication. 

The SQL Profiler allows you to monitor transactions being executed 
against a database.  

1.  Open the profiler from All Programs > Microsoft SQL Server > 

Performance Tools > SQL Server Profiler. 

2.  Click File > New Trace and connect to the server. 

3.  In the Events tab, select the following events: 

ƒ  Stored Procedures RPC:Completion 
ƒ  TSL SQL:BatchCompleted 

4.  Click Run. 

You can also choose to filter the requests, for example by Application 
Name. Most Management Portal requests will show as Management