Reconfiguration and Upgrade Guide for Cisco Unity Release 5.x (With Microsoft Exchange)
Upgrading and Downgrading SQL Server 2000 and MSDE 2000
Downloads: This chapterpdf (PDF - 110.0KB) The complete bookPDF (PDF - 6.98MB) | Feedback

Upgrading and Downgrading SQL Server 2000 and MSDE 2000

Table Of Contents

Upgrading and Downgrading SQL Server 2000 and MSDE 2000

Upgrading from MSDE 2000 to SQL Server 2000

Downgrading from SQL Server 2000 to MSDE 2000


Upgrading and Downgrading SQL Server 2000 and MSDE 2000


This chapter contains the following sections:

Upgrading from MSDE 2000 to SQL Server 2000

Downgrading from SQL Server 2000 to MSDE 2000

Upgrading from MSDE 2000 to SQL Server 2000

Revised May 6, 2009

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.)

Do the following two procedures.

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 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 the Cisco Unity System Preparation 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 Exit the Cisco Unity software. For details, see the "Exiting the Cisco Unity Software" section on page A-1.

Step 3 On Cisco Unity Service Packs CD 1, browse to the Cuspa directory, and double-click Cuspa.vbs.

If you are accessing the Cisco Unity System Preparation Assistant files on another server, use Windows Explorer or the "net" command to map the network drive to a drive letter on the Cisco Unity server before you run Cuspa.vbs.

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

Step 5 On the Welcome screen, click Next.

Step 6 On the Cisco Unity Server Characteristics page, set the following fields:

Configuration

Click the applicable value, Voice Messaging Only or Unified Messaging

Failover

Check this check box if you upgraded to SQL Server 2000 because you are configuring Cisco Unity failover.

Number of Ports

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


Step 7 Click Next. The assistant lists the components and indicates whether or not they are installed.

Step 8 Follow the prompts to install any missing components until you are prompted to install 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 9 Install SQL Server 2000 Service Pack 4:

a. On the Welcome screen, click Next.

b. Follow the on-screen prompts until you are prompted to choose the authentication mode.

c. Choose Windows authentication, and click Next.

d. If the SA Password Warning dialog box appears, enter and confirm the password, and click Next.

e. Follow the on-screen prompts to continue.

f. If you are prompted about shutdown tasks before continuing with the installation, click Next.

g. Click Finish to begin installing components.

h. When the Setup message appears, click OK.

i. Click Finish to restart the server.


Downgrading from SQL Server 2000 to MSDE 2000

Revised May 6, 2009

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 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 MSDE 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 Exit the Cisco Unity software. For details, see the "Exiting the Cisco Unity Software" section on page A-1.

Step 3 On Cisco Unity Service Packs CD 1, browse to the Cuspa directory, and double-click Cuspa.vbs.

If you are accessing the Cisco Unity System Preparation Assistant files on another server, use Windows Explorer or the "net" command to map the network drive to a drive letter on the Cisco Unity server before you run Cuspa.vbs.

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

Step 5 On the Welcome screen, click Next.

Step 6 On the Cisco Unity Server Characteristics page, set the following fields:

Configuration

Click the applicable value, Voice Messaging Only or Unified Messaging

Failover

Check this check box if you upgraded to SQL Server 2000 because you are configuring Cisco Unity failover.

Number of Ports

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


Step 7 Click Next. The assistant lists the components and indicates whether or not they are installed.

Step 8 Follow the prompts to install any missing components until you are prompted to install MSDE 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 9 Install MSDE 2000 Service Pack 4:

a. Follow the on-screen prompts.

b. When the installation is complete, click Yes to restart the server.


To Complete the Downgrade to MSDE 2000


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

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 again.