Explore Cisco
How to Buy

Have an account?

  •   Personalized content
  •   Your products and support

Need an account?

Create an account

Staging Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted, Release 10.5(1)

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Book Contents
Find Matches in This Book
Available Languages
Download Options

Book Title

Staging Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted, Release 10.5(1)

Chapter Title

Microsoft SQL Server Staging

Results

Updated:
July 17, 2017

Chapter: Microsoft SQL Server Staging

Microsoft SQL Server Staging

Microsoft SQL Server Component Installation

To install Microsoft SQL Server, complete the following tasks:

Install Microsoft SQL Server

Install Microsoft SQL Server 2008 R2. Store the SQL Server log and temporary files on the same physical disk as the operating system (typically the C drive). Store the Logger database on the secondary drive (typically the E drive).


Note

For information about supported versions, editions, and service packs, see the Compatibility Matrix for Unified CCE at http:/​/​docwiki.cisco.com/​wiki/​Compatibility_​Matrix_​for_​Unified_​CCE.

Procedure
    Step 1   Mount the Microsoft SQL Server ISO image to the virtual machine.
    Step 2   Run setup.exe.
    Step 3   Select Installation on the left pane, and then select New installation or add features to an existing installation.
    Step 4   Click OK.
    Step 5   On the Setup Support Rules page, click OK.
    Step 6   On the Product Key page, enter the product key and click Next.
    Step 7   Select the I accept the license terms check box, and click Next.
    Step 8   On the Setup Support Files page, click Install. The Setup Support Files page updates with the status of several SQL Server Setup support files.
    Step 9   Click Next.
    Step 10   On the Setup Role page, select SQL Server Feature Installation. Click Next.
    Step 11   On the Feature Selection page, select only the following and then click Next.
    1. Database Engine Services
    2. Client Tools Connectivity
    3. SQL Server Books Online
    4. Management Tools - Basic
    5. Management Tools - Complete
    6. SQL Client Connectivity SDK
    Step 12   On the Installation Rules page, click Next.
    Step 13   On the Instance Configuration page, select Default Instance. Click Next.
    Step 14   On the Disk Space Requirements page, click Next.
    Step 15   On the Server Configuration page, select the Services Account tab.
    1. For Service SQL Server Agent, select Account Name: NT AUTHORITY\Network Services and Startup Type: Automatic.
    2. For Service SQL Server Database Engine, select Account Name: NT AUTHORITY\Network Services and Startup Type: Automatic.
    Important:

    Set the server's default language to English (US) in the server properties. Unified CCE expects the server to use the US date format of MDY. Many European languages use the European date format of DMY instead. This mismatch causes queries like select * from table where date = '2012-04-08 00:00:00' to return data for the wrong date. Handle localization in the client application, like Cisco Unified Intelligence Center.

    Step 16   Remain on the Server Configuration page and select the Collation tab.
    1. Click Customize.
    2. Click the Windows Collation designator and sort order radio button.
    3. Select the applicable collation and sort order. Typically, choose the SQL Server collation that supports the Windows system locale that the customer most commonly uses (for example, Latin1_General collation and Binary sort order for English).
      Attention:

      The collation you select affects what can be written to the database. For example, if you set the collation for Latin1_General and an agent enters Chinese characters in a field, the database cannot save the field value with those unsupported characters.

      Additionally, it is critical to select the correct collation setting for the end user's language display during installation. If you do not select the correct collation during installation, you must uninstall and reinstall Microsoft SQL Server.

      Windows Language SQL Server Collation Setting

      English

      Danish

      Dutch

      French

      German

      Italian

      Portuguese (Brazil)

      Spanish (Spain)

      Swedish

      Latin1_General

      Russian Cyrillic General
      Chinese (China) Chinese_PRC
      Chinese (Taiwan) Chinese_Taiwan_Stroke
      Korean Korean_Wansung
      Japanese Japanese
    4. Click OK. Click Next on the Server Configuration page.
    Step 17   On the Database Engine Configuration page, do the following steps:
    1. On the Account Provisioning tab, check Mixed Mode as the Authentication Mode.
    2. Enter the SQL Server system administrator (sa) account password and confirm it by reentering it.
    3. (Optional) To add the user who is installing the SQL Server as an administrator, click Add Current User.
    4. Click Next.
    Step 18   Click Next on the Error Reporting page.
    Step 19   Click Next on the Installation Configuration Rules page.
    Step 20   Click Install on the Ready to Install page.
    Step 21   Click Close at the Complete page.
    Step 22   Install SQL Server Service Pack. Follow the Wizard and accept all defaults.
    Step 23   Enable Named Pipes and set the sort order as follows:
    1. Open the SQL Server Configuration Manager.
    2. In the left pane, navigate to SQL Native Client 10.0 Configuration (32bit) > Client Protocols.
    3. In the right pane, right-click Named Pipes and confirm that Enable is selected.
    4. In the Client Protocols Properties window, select Named Pipes and click Move Up or Move down to change the order of the protocols as follows: Shared Memory, Named Pipes, TCP/IP, then click OK.
    5. In the left pane, navigate to SQL Server Network Configuration > Protocols for MSSQLSERVER.
    6. In the right pane, right-click Named Pipes and select Enable.
    Note   

    By default, Microsoft SQL Server dynamically resizes its memory. The SQL Server reserves the memory based on process demand. The SQL server releases the memory only when other processes request it, which can cause unnecessary memory monitoring tool alerts.

    Cisco supports the Microsoft recommendation to dynamically manage the SQL Server memory. If your solution raises too many memory alerts, you can manually limit SQL Server’s memory usage, set the maximum limit of the memory with the maximum memory usage settings in the SQL Server Properties menu.

    For more information on SQL Server memory settings and use, see the Microsoft SQL Server documentation

    Step 24   Restart the SQL Server service by selecting Start > All Programs > Administrative Tools > Services. Right-click SQL Server (MSSQLSERVER) and select Stop. Right-click it again and select Start.
    Step 25   Ensure that the SQL Server Browser is started:
    1. Open the services panel from Control Panel.
    2. Navigate to the SQL Server Browser.
    3. Right-click to open the Properties window.
    4. Enable the service and change the startup type to Automatic.


    Note

    The SQL Server 2008 R2 installation disables the Windows' Computer Browser service. The ICMDBA requires that service to run some of its functionality. If you need to run ICMDBA on this server, enable the Computer Browser service.

    What to Do Next

    Assign the Perform Volume Maintenance Tasks privilege by using the Microsoft Local Security Policy Tool from an administrator account. This privilege determines which users and groups can run maintenance tasks on a volume. (Refer to Microsoft documentation for more details.) When you finish the CCE installation or upgrade, remove the Perform Volume Maintenance Tasks privilege.

    Set Users as System Administrators

    Any users who are involved in installing or upgrading a Unified ICM/CCE & Hosted solution must be added as part of SQL Server Security login and associated with the System Administrator role. Complete the following steps to set a user as a System Administrator:

    Procedure
      Step 1   Open the Microsoft SQL Server Management Studio using the System Administrator login credentials.
      Step 2   In the Object Explorer pane, click the Security folder.

      The Security folder expands.

      Step 3   Right-click the Logins folder, and then click New Login.

      The Login-New view appears.

      Step 4   In the Login name field, enter the Windows login name of the user whom you want to associate with the System Administrator role.
      Step 5   Click OK.
      Step 6   In the Object Explorer pane, click the Server Roles folder.

      The Server Roles view appears.

      Step 7   Check the sysadmin check box.
      Note    This step is mandatory.

      System administrator is a predefined fixed server-level role in the Microsoft SQL Server. The system administrator performs operations on a site-level. System administrators manage jobs, role definitions, and shared schedules that are used to run reports.

      You must be a system administrator to create, modify, and delete individual records in the Configuration Manager tool.

      For details about the sysadmin role, see the Microsoft SQL documentation.

      Step 8   Click OK.

      The user is now a part of the SQL Security login and is also associated with the System Administrator role.

      Verify the SQL Protocol Order

      After you install Microsoft SQL Server, enable Named Pipes, and set the protocol sort order.
      Procedure
        Step 1   Click Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager.
        Step 2   In the left pane, navigate to SQL Native Client 10.0 Configuration (32bit) > Client Protocols.
        Step 3   In the right pane, right-click Named Pipes and select Order.
        Step 4   In the Client Protocols Properties window, select Named Pipes and click the up arrow to move Named Pipes above TCP/IP, and then click OK.
        Step 5   In the left pane, navigate to SQL Native Client 10.0 Configuration > Client Protocols.
        Step 6   In the right pane, right-click Named Pipes and select Order.
        Step 7   In the Client Protocols Properties window, select Named Pipes and click the up arrow to move Named Pipes above TCP/IP, and then click OK.
        Step 8   In the left pane, navigate to SQL Server Network Configuration > Protocols for MSSQLSERVER.
        Step 9   In the right pane, right-click Named Pipes and select Enable from the list.

        Increase Database and Log File Size

        Use the Microsoft SQL Server Management Studio to increase the database, and log sizes.

        For the Tempdb, follow these guidelines:

        • For Data Files:

          • Set the Space Allocated to 1400 MB.

          • Set Automatically grow files to 100MB.

          • Set Unrestricted file growth.

        • For Transaction Log Files, follow these guidelines:

          • Set the Space Allocated to 400 MB.

          • Set Automatically grow files to 10%.

          • Set Unrestricted file growth.

          • In the Options page, ensure that the following options are set to False: ANSI NULL Enabled, Recursive triggers Enabled, Auto close, Auto shrink and Quoted identifiers Enabled.

        Was this Document Helpful?

        FeedbackFeedback

        Contact Cisco