AVVID Troubleshooting Tools © 2004 Cisco Systems, Inc. All rights reserved. Using Database Tools IPTT v4.03-1

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Database Tools: Objectives Upon completing this lesson, you will be able to: Recognize Microsoft SQL Server functions Describe SQL enterprise manager functions Describe the process for reestablishing replication using Enterprise Manager and DBLHelper Describe SQL command line utilities Interpret Microsofts SQL command utilities output Describe AVVID directory service utilities

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Overview Introduction to Microsoft SQL Server 2000 Microsoft SQL Enterprise Manager Re-Creating Subscriber Connections Microsoft SQL Query Analyzer Microsoft SQL Command-Line Utilities Cisco AVVID Directory Service Utilities Summary Quiz Outline

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Microsoft SQL Database Replication Changes made to the database replicate via a transactional process. If the link is down, SQL keeps a transaction log and replicates the data when possible. Replication Direction Client Publisher Client Subscriber SQL Client Subscriber SQL Client Computer SQL

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Database Services and Microsoft SQL

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Publisher or Subscriber Database PublisherSubscriber

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Publisher or Subscriber Database (Cont.) Publisher database: Can also be recognized by the presence of a replication monitor Red circle with a white X in it indicates an error Three important replication agents: –Snapshot agent –Log reader agent –Distribution agent

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Database Replication Glass House Backup SQL ComputerApplicationDatabase Access Replication Direction

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Recreating Subscriber Connections Publisher Subscriber On subscriber (manual process) Check status of subscriber database. Delete subscriptions. Recreate subscriptions. On publisher (manual process) Reinitialize subscriptions. Start the replication snapshot agent. DBLHelper Obtain DBLHelper from your service provider before you need it. Publish then initialize.

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Restore Directory Server SQL Server 7.0 SQL Server 7.0 SQL Server 7.0 LDAP v3 Directory LDAP v3 Directory LDAP v3 Directory Administrator Console CCM 4.0 (Glass House) CCM 4.0 DB Access Directory Access DB Replication Directory Replication

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Microsoft SQL Server Query Analyzer

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Command-Line Example

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Microsoft Command-Line Utilities nslookup netstat - a ping net start

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Cisco CallManager versions 3.1 and 3.2 avvid_cfg avvid_scfg avvid_del avvid_imp avvid_recfg avvid_save avvid_restore cleandsa Cisco AVVID Directory Service Utilities

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Cisco AVVID Directory Service Utilities (Cont.) Cisco CallManager versions 3.3 and 4.0 reconfig_cluster clean_publisher avvid_srepl avvid_migrate_save avvid_migrate_restore

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v DC Directory Tools in Cisco CallManager 3.3 and 4.0 CCMRegBrowser: Checks DC Directory version, install status, password CCMPWDChanger: Updates the password of CCM Users such as Directory Manager, CCMSysUser Both tools located C:\DCDSrvr\Bin Cisco AVVID Directory Service Utilities (Cont.)

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Restoring DC Directory Services

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Summary Microsoft SQL Server 2000 integrates with Cisco Call Manager components and writes information to the publisher database. Use the Microsoft SQL Enterprise Manager to identify the publisher and subscriber SQL servers. Microsoft SQL Query Analyzer is a tool that allows you to search database tables for specific data. Microsoft SQL command-line utilities allow you to initiate queries, perform diagnostics, and troubleshoot the Microsoft SQL Server 2000 database. Cisco AVVID directory service command-line utlities allow you to restore a DC Directory database MetaLink connection between server nodes.

© 2004 Cisco Systems, Inc. All rights reserved. IPTT v Lesson Review 1. Which database contains the writable copy of the database? 2. Which Microsoft SQL Server 2000 database component does the publisher create? 3. Which two utilities allow you to view tables inside the Microsoft SQL Server 2000 database? 4. Which command-line utility would you use to determine open port numbers on your CCM server? 5. Which Cisco AVVID command-line utility would you use to initialize and configure the DC Directory on the publisher server using CallManager version 3.3?