Guest

Cisco Unified Intelligent Contact Management Enterprise

Microsoft SQL Server 2000 Setup Configuration for ICM 6.0 and 7.0

Cisco - Microsoft SQL Server 2000 Setup Configuration for ICM 6.0 and 7.0

Document ID: 63991

Updated: Nov 21, 2006

   Print

Introduction

This document outlines the procedure to set up Microsoft® SQL Server 2000 for use with Cisco Intelligent Contact Management (ICM) versions 6.0 and 7.0. It covers only the new installation of SQL Server 2000 in ICM version 6 and 7 environments.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

  • Cisco ICM databases

  • Microsoft SQL Server database connectivity

  • Microsoft Windows connectivity

Components Used

The information in this document is based on these software and hardware versions:

  • Cisco ICM versions 6.0 and 7.0

  • Microsoft SQL Server 2000

  • Microsoft Windows 2000 Server with Service Pack 4

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

SQL Server 2000 Installation

Complete this step-by-step procedure to install SQL Server 2000 on Loggers, Historical Data Servers (HDS), Admin Workstations (AW), LGMappers and LGArchivers.

  1. Log on to the operating system under a user account that has local administration permissions, or assign the appropriate permissions to the domain user account.

  2. Shut down all services dependent on SQL Server. This includes any service that uses ODBC, such as Microsoft Internet Information Services (IIS).

  3. Shut down Microsoft Windows NT Event Viewer and registry viewers (regedit.exe or regedt32.exe).

  4. Insert the installation disk for Microsoft SQL 2000 Standard Edition to start the SQL Server setup program. The setup window is displayed (see Figure 1).

    Figure 1 – SQL Server 2000 Standard Edition Setup Screen

    sql_server2k_63991_01.gif

  5. Click SQL Server 2000 Components. The Install Components window is displayed (see Figure 2).

    Figure 2 – SQL Server 2000: Install Components Screen

    sql_server2k_63991_02.gif

  6. Click Install Database Server. The Welcome window is displayed (see Figure 3).

    Figure 3 – Welcome Screen

    sql_server2k_63991_03.gif

  7. Click Next. The Computer Name window is displayed (see Figure 4).

    Figure 4 – Computer Name Screen

    sql_server2k_63991_04.gif

  8. Choose the Local Computer option, and click Next. The Installation Selection window is displayed (see Figure 5).

    Figure 5 – Installation Selection Screen

    sql_server2k_63991_05.gif

  9. Click Create a new instance of SQL Server, or install Client Tools, and click Next. The User Information window is displayed (see Figure 6).

    Figure 6 – User Information Screen

    sql_server2k_63991_06.gif

  10. Enter the customer name in the Name field, and the company name in the Company field.

  11. Click Next. The Software License Agreement window is displayed (see Figure 7).

    Figure 7 – Software License Agreement Screen

    sql_server2k_63991_07.gif

  12. Click Yes to agree to the License Agreement. The Installation Definition window is displayed (see Figure 8).

    Figure 8 – Installation Definition Screen

    sql_server2k_63991_08.gif

  13. Click Server and Client Tools, and click Next. The Instance Name window is displayed (see Figure 9).

    Figure 9 – Instance Name Screen

    sql_server2k_63991_09.gif

  14. Check the Default check box, and click Next. The Setup Type window is displayed (see Figure 10).

    Figure 10 – Setup Type Screen

    sql_server2k_63991_10.gif

  15. Click Custom. Then, click the Browse button to choose the preferred disk for both Program Files and Data Files. The C: drive is chosen by default.

  16. Click Next. The Select Components window is displayed (see Figure 11).

    Figure 11 – Select Components Screen

    sql_server2k_63991_11.gif

  17. Retain the default selections under Components and Sub-Components, and click Next. The Services Accounts window is displayed (see Figure 12).

    Figure 12 – Services Accounts Screen (SQL Server)

    sql_server2k_63991_12.gif

  18. Click Customize the settings for each service.

  19. Choose the SQL Server option under the Services section, and the Use the Local System account option under the Service Settings section (see Figure 12). Check the Auto Start Service check box to select it.

  20. Choose the SQL Server Agent option under the Services section, and the Use the Local System account option under the Service Settings section (see Figure 13). Check the Auto Start Service check box to select it.

    Figure 13 – Services Accounts Screen (SQL Server Agent)

    sql_server2k_63991_13.gif

  21. Click Next. The Authentication Mode window is displayed (see Figure 14).

    Figure 14 – Authentication Mode Screen

    sql_server2k_63991_14.gif

  22. Choose the Mixed Mode (Windows Authentication and SQL Server Authentication) option, and check the Blank Password (not recommended) check box.

  23. Click Next. The Collation Settings window is displayed (see Figure 15).

    Figure 15 – Collation Settings Screen

    sql_server2k_63991_15.gif

  24. Click Collation designator, and choose Latin1_General from the pull-down list. Check the Binary check box in the Sort order section.

  25. Click Next. The Network Libraries window is displayed (see Figure 16).

    Figure 16 – Network Libraries Screen

    sql_server2k_63991_16.gif

  26. Check the Named Pipes check box. By default, \\. \pipe\sql\query appears in the Named Pipe Name field. Retain this default pipe name as it is.

  27. Check the TCP/IP Sockets check box. 1433 appears in the Port number field. Retain this default number as it is.

  28. Click Next. The Start Copying Files window is displayed (see Figure 17).

    Figure 17 – Start Copying Files Screen

    sql_server2k_63991_17.gif

  29. Read the information displayed in the Start Copying Files window, and then click Next. The Choose Licensing Mode window is displayed (see Figure 18).

    Figure 18 – Choose Licensing Mode Screen

    sql_server2k_63991_18.gif

  30. Choose the Per Seat option in the Licensing Mode section, and set 40 devices at least.

  31. Click Continue. A message is displayed to indicate that the installation of Microsoft Data Access Components (MDAC) is in progress (see Figure 19).

    Figure 19 – Installation in Progress

    sql_server2k_63991_19.gif

  32. Click OK if a message box prompts you to configure SQL Agent.

    When the installation of SQL Server 2000 is complete, the Setup Complete window is displayed (see Figure 20).

    Figure 20 – Setup Complete Screen

    sql_server2k_63991_20.gif

  33. Click Finish to complete the setup.

  34. Restart the computer.

Related Information

Updated: Nov 21, 2006
Document ID: 63991