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.
Cisco recommends that you have knowledge of these topics:
- Cisco ICM databases
- Microsoft SQL Server database connectivity
- Microsoft Windows connectivity
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.
Refer to
Cisco Technical Tips Conventions for more information on document conventions.
Complete this step-by-step procedure to install SQL Server 2000 on
Loggers, Historical Data Servers (HDS), Admin Workstations (AW),
LGMappers and LGArchivers.
- 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.
- Shut down all services dependent on SQL Server. This includes
any service that uses ODBC, such as Microsoft Internet Information
Services (IIS).
- Shut down Microsoft Windows NT Event Viewer and registry viewers (regedit.exe or regedt32.exe).
- 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
- Click SQL Server 2000 Components. The Install Components window is displayed (see Figure 2).
Figure 2 – SQL Server 2000: Install Components Screen
- Click Install Database Server. The Welcome window is displayed (see Figure 3).
Figure 3 – Welcome Screen
- Click Next. The Computer Name window is displayed (see Figure 4).
Figure 4 – Computer Name Screen
- Choose the Local Computer option, and click Next. The Installation Selection window is displayed (see Figure 5).
Figure 5 – Installation Selection Screen
- 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
- Enter the customer name in the Name field, and the company name in the Company field.
- Click Next. The Software License Agreement window is displayed (see Figure 7).
Figure 7 – Software License Agreement Screen
- Click Yes to agree to the License Agreement. The Installation Definition window is displayed (see Figure 8).
Figure 8 – Installation Definition Screen
- Click Server and Client Tools, and click Next. The Instance Name window is displayed (see Figure 9).
Figure 9 – Instance Name Screen
- Check the Default check box, and click Next. The Setup Type window is displayed (see Figure 10).
Figure 10 – Setup Type Screen
- 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.
- Click Next. The Select Components window is displayed (see Figure 11).
Figure 11 – Select Components Screen
- 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)
- Click Customize the settings for each service.
- 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.
- 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)
- Click Next. The Authentication Mode window is displayed (see Figure 14).
Figure 14 – Authentication Mode Screen
- Choose the Mixed Mode (Windows Authentication and SQL Server Authentication) option, and check the Blank Password (not recommended) check box.
- Click Next. The Collation Settings window is displayed (see Figure 15).
Figure 15 – Collation Settings Screen
- Click Collation designator, and choose Latin1_General from the pull-down list. Check the Binary check box in the Sort order section.
- Click Next. The Network Libraries window is displayed (see Figure 16).
Figure 16 – Network Libraries Screen
- 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.
- Check the TCP/IP Sockets check box. 1433 appears in the Port number field. Retain this default number as it is.
- Click Next. The Start Copying Files window is displayed (see Figure 17).
Figure 17 – Start Copying Files Screen
- 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
- Choose the Per Seat option in the Licensing Mode section, and set 40 devices at least.
- 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
- 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
- Click Finish to complete the setup.
- Restart the computer.
