Cisco Cisco Agent Desktop 8.5 故障排查指南

Cisco CAD Troubleshooting Guide

54

April 3, 2014

This can be simulated with the Run-As feature in Windows. To use the Run-As 
feature on versions of Windows prior to Server 2008, right-click on the 
command prompt executable and select Run as. For Server 2008 and later, 
hold down the Shift key, then right-click on the command prompt executable 
and select Run as different user. 

For more information about provisioning users for SQL refer to the Cisco CAD 
Installation Guide. 

http://technet.microsoft.com/library/Cc966485#ECAA

4. Ensure that CAD SQL instance password does not contain any special 

characters (for example, & | = ; <). Although these are valid characters per 
MSSQL specification, they will not work with the CAD scripts that interface 
with the SQL engine.

5. In SQL Server Management Studio, connect to the CAD SQL instance and run 

the 

sp_helpserver

 query. If the server name given does not match what the 

CAD SQL instance recognizes as the server name, then you must change the 
server name in SQL Server Management Studio. To change the server name:

a. Run the query: 

sp_dropserver ‘<server name>\<instance>’,‘droplogins’

 

where: 

<server name>

 is the incorrect server name given by the 

sp_helpserver

 

query 

<instance>

 is the name of the CAD SQL instance 

Click Ok.

b. Then run the query: 

sp_addserver ‘<server name>\<instance>’,‘local’

 

where: 

<server name>

 is the correct server name

<instance>

 is the name of the CAD SQL instance

c. Click Ok.

6. Ensure there are no firewall issues between the primary and secondary 

systems. For troubleshooting, turn the firewalls off completely on both 
systems. At the minimum, firewall exceptions are required for SQL Server, SQL 
Server Agent, and SQL Server Browser for the SQL Server instance CAD uses 
on both servers.