Reconfiguration and Upgrade Guide for Cisco Unity Release 8.x (With Microsoft Exchange)
Upgrading or Downgrading SQL Server, SQL Server Express, and MSDE for the Cisco Unity 8.x System
Downloads: This chapterpdf (PDF - 118.0KB) The complete bookPDF (PDF - 7.03MB) | Feedback

Upgrading or Downgrading SQL Server, SQL Server Express, and MSDE for the Cisco Unity 8.x System

Table Of Contents

Upgrading or Downgrading SQL Server, SQL Server Express, and MSDE for the Cisco Unity 8.x System

Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (Without Failover)

Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (With Failover Configured)

Upgrading from MSDE 2000 to SQL Server 2000f or the Cisco Unity 8.x System

Downgrading from SQL Server 2000 to MSDE 2000 for the Cisco Unity 8.x System


Upgrading or Downgrading SQL Server, SQL Server Express, and MSDE for the Cisco Unity 8.x System


This chapter contains the following sections:

Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (Without Failover)

Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (With Failover Configured)

Upgrading from MSDE 2000 to SQL Server 2000f or the Cisco Unity 8.x System

Downgrading from SQL Server 2000 to MSDE 2000 for the Cisco Unity 8.x System

Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (Without Failover)

To Upgrade from SQL Server 2000 to SQL Server 2005 Without Failover


Step 1 Refer to the antivirus software documentation to determine the names of the antivirus services.

Step 2 On the primary server, on the Windows Start menu, click Programs > Administrative Tools > Services.

Step 3 Disable and stop each antivirus service and the Cisco Security Agent service:

a. In the right pane, double-click the service.

b. On the General tab, in the Startup Type list, click Disabled. This prevents the service from starting when you restart the server.

c. Click Stop to stop the service immediately.

d. Click OK to close the Properties dialog box.

Step 4 Close the Services MMC.

Step 5 In the Windows task bar, right-click the Cisco Unity tray icon and click Stop Unity.

Step 6 After Cisco Unity has stopped, right-click the Cisco Unity tray icon and click Exit.

Step 7 Stop and disable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Disabled.

d. If the value of Service Status is started, click Stop.

e. Click OK to close the Properties dialog box.

f. Close the Services MMC.

Step 8 On the Cisco Unity Data Store 2005 DVD, browse to the UnityScripts directory.

Step 9 Double-click FixWMI.cmd.

When the script is complete, the command window closes automatically

Step 10 Double-click FixWMI2.cmd.

When the script is complete, the command window closes automatically

Step 11 Upgrade from SQL Server 2000 to SQL Server 2005:

a. Open a command window.

b. Change the current directory to SQL2005\Servers.

c. Run the following command. Note that you must enter all quotation marks (").

setup.exe /qb UPGRADE=SQL_Engine,SQL_Data_Files ADDLOCAL=SQL_Replication,SQL_FullText,SQL_Tools90,TOOLS_BC_DEP INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" SQLACCOUNT="NT AUTHORITY\SYSTEM" AGTACCOUNT="NT AUTHORITY\SYSTEM" ASACCOUNT="NT AUTHORITY\SYSTEM" RSACCOUNT="NT AUTHORITY\SYSTEM" SQLAUTOSTART=1 REINSTALLMODE=OMUS DISABLENETWORKPROTOCOLS=0

When the upgrade finishes, the SQL Server installation and upgrade wizard closes.

Step 12 Re-enable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Automatic.

d. Click OK to close the Properties dialog box.

e. Close the Services MMC.

Step 13 Restart the Cisco Unity server.

Step 14 In the Windows task bar, right-click the Cisco Unity tray icon and click Stop Unity.

Step 15 After Cisco Unity has stopped, right-click the Cisco Unity tray icon and click Exit.

Step 16 Stop and disable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Disabled.

d. If the value of Service Status is started, click Stop.

e. Click OK to close the Properties dialog box.

f. Close the Services MMC.

Step 17 Install SQL Server 2005 Service Pack 3:

a. On the Cisco Unity Data Store 2005 DVD, browse to the SQL2005_SP3 directory.

b. Double-click SQLServer2005SP3-KB955706-x86-ENU.exe.

c. On the Finished page, uncheck the check box that causes a provisioning tool for Vista to run.

Step 18 Re-enable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Automatic.

d. Close the Services MMC.

Step 19 Restart the Cisco Unity server to finalize any changes made by SQL Server 2005 Service Pack 3.

Step 20 On the Windows Start menu, click Programs > Administrative Tools > Services.

Step 21 Re-enable and start each antivirus service and the Cisco Security Agent service:

a. In the right pane, double-click the service.

b. On the General tab, in the Startup Type list, click Automatic.

c. Click Start to start the service immediately.

d. Click OK to close the Properties dialog box.

Step 22 Close the Services MMC.


Upgrading from SQL Server 2000 to SQL Server 2005 for the Cisco Unity 8.x System (With Failover Configured)

To Upgrade from SQL Server 2000 to SQL Server 2005 (With Failover Configured)


Step 1 Refer to the antivirus software documentation to determine the names of the antivirus services.

Step 2 On the primary server, on the Windows Start menu, click Programs > Administrative Tools > Services.

Step 3 Disable and stop each antivirus service and the Cisco Security Agent service:

a. In the right pane, double-click the service.

b. On the General tab, in the Startup Type list, click Disabled. This prevents the service from starting when you restart the server.

c. Click Stop to stop the service immediately.

d. Click OK to close the Properties dialog box.

Step 4 Determine which Active Directory account the SQL Server and SQL Server Agent services log on as (both services log on as the same account on both the primary and secondary servers):

a. In the right pane, double-click SQL Server (MSSQLSERVER).

b. In the SQL Server (MSSQLSERVER) Properties dialog box, click the Log On tab.

c. Note the name of the domain and account specified in the This Account field. You will need the account name and the password for the account in Step 13.

d. Click OK to close the Properties dialog box.

Step 5 Close the Services MMC.

Step 6 Fail over to the secondary Cisco Unity server, and disable automatic failback:

a. On the primary Cisco Unity server, on the Windows Start menu, click Programs > Cisco Unity > Failover Monitor.

b. Click Failover.

c. Click Yes to confirm.

d. Click Advanced.

e. Check the Disable Automatic Failover and Failback check box.

f. Uncheck the Enable File Replication check box.

g. Click OK.

h. Close the Failover Monitor.

Step 7 In the Windows task bar, right-click the Cisco Unity tray icon and click Stop Unity.

Step 8 After Cisco Unity has stopped, right-click the Cisco Unity tray icon and click Exit.

Step 9 Stop and disable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Disabled.

d. If the value of Service Status is started, click Stop.

e. Click OK to close the Properties dialog box.

f. Close the Services MMC.

Step 10 On the Cisco Unity Data Store 2005 DVD, browse to the UnityScripts directory.

Step 11 Double-click FixWMI.cmd.

When the script is complete, the command window closes automatically

Step 12 Double-click FixWMI2.cmd.

When the script is complete, the command window closes automatically

Step 13 Upgrade from SQL Server 2000 to SQL Server 2005:

a. Open a command window.

b. Change the current directory to SQL2005\Servers.

c. Run the following command. Note that:

You must enter all quotation marks (").

Domain\Account is the domain and account that SQL Server and SQL Server Agent services log on as. You determined this account in Step 4.

AccountPassword is the password for the account that SQL Server and SQL Server Agent services log on as.

setup.exe /qb UPGRADE=SQL_Engine,SQL_Data_Files ADDLOCAL=SQL_Replication,SQL_FullText,SQL_Tools90,TOOLS_BC_DEP INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" SQLACCOUNT="Domain\Account" SQLPASSWORD="AccountPassword" AGTACCOUNT="NT AUTHORITY\SYSTEM" ASACCOUNT="NT AUTHORITY\SYSTEM" RSACCOUNT="NT AUTHORITY\SYSTEM" SQLAUTOSTART=1 REINSTALLMODE=OMUS DISABLENETWORKPROTOCOLS=0

When the upgrade finishes, the SQL Server installation and upgrade wizard closes.

Step 14 Re-enable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Automatic.

d. Click OK to close the Properties dialog box.

e. Close the Services MMC.

Step 15 Restart the Cisco Unity server.

Step 16 In the Windows task bar, right-click the Cisco Unity tray icon and click Stop Unity.

Step 17 After Cisco Unity has stopped, right-click the Cisco Unity tray icon and click Exit.

Step 18 Stop and disable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Disabled.

d. If the value of Service Status is started, click Stop.

e. Click OK to close the Properties dialog box.

f. Close the Services MMC.

Step 19 Install SQL Server 2005 Service Pack 3:

a. On the Cisco Unity Data Store 2005 DVD, browse to the SQL2005_SP3 directory.

b. Double-click SQLServer2005SP3-KB955706-x86-ENU.exe.

c. On the Finished page, uncheck the check box that causes a provisioning tool for Vista to run.

Step 20 Re-enable the AvCsGateway service:

a. On the Windows Start menu, click Programs > Administrative Tools > Services.

b. In the right pane of the Services MMC, right-click AvCsGateway, and click Properties.

c. In the Startup Type list, click Automatic.

d. Close the Services MMC.

Step 21 Restart the Cisco Unity primary server to finalize any changes made by SQL Server 2005 Service Pack 3.

Step 22 On the Windows Start menu, click Programs > Administrative Tools > Services.

Step 23 Re-enable and start each antivirus service and the Cisco Security Agent service:

a. In the right pane, double-click the service.

b. On the General tab, in the Startup Type list, click Automatic.

c. Click Start to start the service immediately.

d. Click OK to close the Properties dialog box.

Step 24 Close the Services MMC.

Step 25 Make the primary server the active server, and make the secondary server inactive:

a. After the primary Cisco Unity server has started successfully, on the primary server, on the Windows Start menu, click Programs > Cisco Unity > Failover Monitor.

b. Click Force Active to make the primary Cisco Unity server active.

c. Click Yes to confirm.

d. Close the Failover Monitor.

e. On the secondary server, on the Windows Start menu, click Programs > Cisco Unity > Failover Monitor.

f. Click Force Inactive to deactivate the secondary Cisco Unity server.

g. Click Yes to confirm.

h. Close the Failover Monitor.

Step 26 Do Step 7 through Step 24 on the secondary server.

Step 27 Enable automatic failover and failback:

a. On the secondary server, open the Failover Monitor.

b. Click Advanced.

c. Uncheck the Disable Automatic Failover and Failback check box.

d. Click OK.

e. Close the Failover Monitor.


Upgrading from MSDE 2000 to SQL Server 2000f or the Cisco Unity 8.x System

You upgrade from MSDE 2000 to SQL Server 2000 for the following scenarios:

You are adding ports to the Cisco Unity system, and the upgraded system will have more than 32 ports.


Caution If you upgrade the Cisco Unity server to more than 32 ports without upgrading to SQL Server 2000, Cisco Unity may not function properly.

You are adding a pair of Cisco Unity failover servers. SQL Server 2000 must be installed on the primary and secondary servers. (MSDE 2000 is not supported on either server with Cisco Unity failover.)

To complete the upgrade, you must install SQLServer 2000 Service Pack 4 by using the Cisco Unity Setup and Cisco Unity Prerequisites DVDs. If you do not have the DVDs available, download them from Cisco.com. Note the following considerations:

The download may be 200 MB or more. Use a computer with a high-speed Internet connection, and confirm that the computer has sufficient disk space or has access to a network drive with sufficient disk space.

The downloads is a self-extracting executable file. When the download is complete, extract the Cisco Unity System Setup Assistant, then delete the downloaded .exe files to free disk space.

The documentation instructs you when to install the software you download.

For information on downloading the Cisco Unity Setup and Cisco Unity Prerequisites DVDs, see the "Installation and Upgrade" section of the release notes for the applicable version of Cisco Unity at http://www.cisco.com/en/US/products/sw/voicesw/ps2237/prod_release_notes_list.html.

Do the following two procedures in the order listed.

To Upgrade from MSDE 2000 to SQL Server 2000


Step 1 Log on to Windows.

Step 2 Exit the Cisco Unity software. For details, see the "Exiting the Cisco Unity 8.x Software" section on page A-1.

Step 3 Insert the Cisco Unity Data Store 2000 disc in the CD-ROM drive.

If the CD does not run automatically, browse to the root directory, and double-click Autorun.exe.

Step 4 Click SQL Server 2000 Components.

Step 5 Click Install Database Server.

Step 6 In the Welcome dialog box, click Next.

Step 7 In the Computer Name dialog box, click Next to accept the default setting Local Computer.

Step 8 In the Installation Selection dialog box, click Upgrade, Remove, or Add Components to an Existing Instance of SQL Server, and click Next.

Step 9 Follow the on-screen prompts until the Upgrade dialog box appears.

Step 10 In the Upgrade dialog box, check the Yes, Upgrade My Programs check box, and click Next.

Step 11 In the Choose Licensing Mode dialog box, click Processor License For, and enter the number of processors in the Cisco Unity server.

Step 12 Click Continue.

Step 13 Click Yes to install additional components.

Step 14 In the Select Components dialog box, check the check boxes for the following components:

Server Components, and all subcomponents.

Management Tools, and all subcomponents.

Client Connectivity.

Step 15 Click Next.

Step 16 In the Start Copying Files dialog box, click Next.

Step 17 Click Finish.


To Run Cisco Unity System Setup Assistant to Install SQL Server 2000 Service Pack 4


Step 1 Log on to Windows by using an account that is a member of the local Administrators group.

Step 2 If Cisco Unity DVD 1 or the Cisco Unity Prerequisites DVD is located on a network share, authenticate on the other server before you continue. For example, start Windows Explorer, browse to the network share, and, when prompted, enter the username and password for an Active Directory account that has access to that location.

Step 3 If Internet Explorer Enhanced Security is enabled on the Cisco Unity server, add the network share as a local intranet site in Internet Explorer. IE Enhanced Security is explained in the Knowledge Base article Internet Explorer Enhanced Security Configuration Changes the Browsing Experience (KB815141), available on the Microsoft website.

Step 4 In the root directory of Cisco Unity DVD 1, double-click Setup.exe.

Step 5 If prompted, double-click the language of your choice to continue the installation.

Step 6 Verify that Review and Install System Prerequisites is selected, and click Run.

Step 7 On the Choose Your Configuration page, set the following fields:

<x> Ports to Be Installed

Enter the number of voice ports that you are connecting with the Cisco Unity server.

This Server Is a Primary or Secondary Server in a Failover Pair

If the server is one of the servers in a failover configuration, check the This Server Is a Primary or Secondary Server in a Failover Pair check box.

Choose the Exchange Version and the Location of the Partner Exchange Server

Choose the Exchange version and configuration.


Step 8 Click Next. The assistant lists the applicable prerequisites and indicates whether or not they are met.

Step 9 Follow the prompts to install any missing components, including SQL Server 2000 Service Pack 4.

If a Microsoft AutoMenu window appears when the assistant is installing an application, close the window and allow the assistant to continue.

Step 10 When the Cisco Unity System Setup Assistant has completed, click Finish.

Downgrading from SQL Server 2000 to MSDE 2000 for the Cisco Unity 8.x System

Before you downgrade to MSDE 2000, back up the Cisco Unity database.

Do the following six procedures in the order listed.

To Back Up the Cisco Unity Database


Back up the UnityDB database by using SQL Server Enterprise Manager. Refer to the Microsoft documentation.


To Uninstall SQL Server 2000


Step 1 On the Windows Start menu, click Settings > Control Panel > Add/Remove Programs.

Step 2 Click Microsoft SQL Server 2000, and click Change/Remove.

Step 3 When the uninstallation is complete, restart the Cisco Unity server. For details, see the "Shutting Down or Restarting the Cisco Unity 8.x Server" section on page A-2.


To Install MSDE 2000


Step 1 Insert the Cisco Unity Data Store 2000 disc in the CD-ROM drive.

Step 2 Browse to the directory MSDE, and double-click Setup.exe.

Step 3 When the installation is complete, click Yes to restart the Cisco Unity server. Leave the Cisco Unity Data Store 2000 disc in the CD-ROM drive.


To Install Enterprise Manager


Step 1 When the Cisco Unity server restarts, log on to Windows.

Step 2 If the Cisco Unity Data Store 2000 disc does not run automatically, browse to the root directory, and double-click Autorun.exe.

Step 3 Click SQL Server 2000 Components.

Step 4 Click Install Database Server.

Step 5 In the Welcome dialog box, click Next.

Step 6 In the Computer Name dialog box, click Next to accept the default setting Local Computer.

Step 7 In the Installation Selection dialog box, click Next to accept the default setting Create a New Instance of SQL Server, or Install Client Tools.

Step 8 Follow the on-screen prompts until the CD Key dialog box appears.

Step 9 Enter the key for Cisco Unity Data Store 2000. The key is located on a sticker on the back of the CD sleeve.

Step 10 Click Next.

Step 11 In the Installation Definition dialog box, click Client Tools Only.

Step 12 Click Next.

Step 13 In the Select Components dialog box, uncheck all check boxes in the Components list except Management Tools.

Step 14 Select Management Tools (but do not uncheck the check box).

Step 15 In the Sub-Components list, uncheck all check boxes except Enterprise Manager, and click Next.

Step 16 In the Start Copying Files dialog box, click Next.

Step 17 Click Finish.


To Install the Latest MSDE 2000 Service Pack and Updates


Step 1 Refer to System Requirements for Cisco Unity and Software Installed by the Cisco Unity Server Updates Wizard at http://www.cisco.com/en/US/products/sw/voicesw/ps2237/prod_installation_guides_list.html to determine the latest MSDE 2000 service pack and updates recommended for use with Cisco Unity.

Step 2 Download the service pack and updates, if any, from the Microsoft website. Also download or print the installation instructions.

You can also download the service pack DVD, which includes the necessary service pack and updates from Cisco.com, http://www.cisco.com/kobayashi/sw-center/sw-voice.shtml.

Step 3 Install the software.

Step 4 If you are prompted to restart the server to complete the installation, do so.


To Complete the Downgrade to MSDE 2000


Step 1 Restart the Cisco Unity server.

Step 2 Using SQL Server Enterprise Manager, restore the database that you backed up in the "To Back Up the Cisco Unity Database" procedure.

Step 3 Restart the Cisco Unity server. For details, see "Shutting Down or Restarting the Cisco Unity 8.x Server" section on page A-2.