Contents

Introduction

Prerequisites

Requirements

Components Used

Configure

Verify

Troubleshoot

Introduction

This document describes the procedure to migrate Cisco Unified Attendant Console (CUAC) Advance version 10.5.2 with SQL Express 2008 from Microsoft Server 2008 to CUAC Advance version 11.0.2 with SQL Express 2008 on Microsoft Server 2012.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

- Cisco Unified Attendant Console Advanced

- Microsoft SQL Server 2008 Express

Components Used

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

- CUAC Advanced 10.5.2

- CUAC Advanced 11.0.2

- Cisco Unified Communications Manager 10.5.2.

- Microsoft SQL Server 2008 Express

- Microsoft Windows Server 2008 R2 Enterprise

- Microsoft Windows Server 2012 R2 Standard

The information in this document is based on devices in 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 Configuration change.

Configure

This table shows the specifications of both from and to systems.

From

To

Version

CUACA 10.5.2

CUACA 11.0.2

Server OS

Server 2008 R2 Enterprise – SP1 64-bit

Server 2012 R2 Standard – 64-bit

Database

SQL 2008 Express Server SP3

SQL 2008 Express Server SP3

Step 1. Ensure that the server to which you wish to migrate meets Cisco Unified Attendant Console Advance hardware and software requirements.

https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucmac/cuaca/11_0_2/install_admin_guide/CUACA110201WAG.pdf

Step 2. Based on supported SQL Express Databases, install respective SQL Express Database. In the Lab Environment, SQL 2008 Express Server SP3 is installed.

Step 3. Refer to CUAC Advanced Administration and Installation Guide for installation of SQL Server 2008.

https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucmac/cuaca/11_0_2/install_admin_guide/CUACA110201WAG.pdf

Note: During the selection of the default instance while installation, the selection of the named instance, names the SQL instance as <Computer name\SQLEXPRESS>. This in turn is an issue while you install Attendant Console Server as it by default assumes SQL Db instance to be <Computername> only this cannot be changed either.

Step 4. After you install the required SQL Express Server, ensure that you can login to it using Microsoft SQL Server Management Studio. In order to enable SA User  navigate to  Microsoft SQL Server Management Studio > Object Explorer > Expand Security > Expand Logins. Now right click sa then select properties and enter Password. Click on Status page Select Enabled under Login, as shown in the image:

Step 5. Restore ATTCFG and ATTLOG from the old CUAC system.

Note: This step is based on SQL database migration procedures in place; however, involvement of a SQL Admin is advised.

Step 6. After the SQL installation is complete with ATTCFG and ATTLOG restored, proceed with installation of CUAC 11.0.2

Follow Cisco Unified Attendant Console Advanced Administration and Installation Guide for CUAC installation.

https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucmac/cuaca/11_0_2/install_admin_guide/CUACA110201WAG.pdf

During installation (Database Wizard), an option on whether you want to overwrite the existing database is asked. This option is because installation setup recognizes the existence of SQL 2008 Express with ATTCFG and ATTLOG. Hence, it needs input from Admin on whether this Db be overwritten.

Click on NO as shown in the image and let the installation proceed further.

Verify

There is currently no verification procedure available for this configuration.

Troubleshoot

There is currently no specific troubleshooting information available for this configuration.