Cisco Cisco Agent Desktop 8.5 Guia De Resolução De Problemas
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.
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.
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.
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:
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.
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.