Cisco Unity

Document ID: 100604

Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Problem
Solution 1
Solution 2
Verify
Cisco Support Community - Featured Conversations
Related Information

Introduction

This document explains how to troubleshoot the error message: failed to configure sql replication that appears when you run the Cisco Unity Failover Configuration Wizard on a Cisco Unity server.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on the Cisco Unity 4.x.

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.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Problem

When the Cisco Unity Failover Configuration Wizard is run on a Ciso Unity server, this error message is received:

failed to configure sql replication

In the diag-failoverconfig.txt, you see this error message:

Error [0x80040afc] : [Microsoft][ODBC SQL Server Driver][SQL Server]
Could not find stored procedure

When the query exec sp_dboption 'UnityDb','published',false is run in the SQL Query Analyzer, this error is returned:

The Distributor has not been installed correctly.  
Could not disable database for publishing.

On the Unity server, go to SQL Enterprise Manager, right-click on the server, and select Properties. Under the Replication tab, the option to Disable Publishing and Distribution is greyed out. This implies that the SQL publishing is not started or configured correctly, which in turn causes the SQL replication failure.

Solution 1

Use this solution to solve the problem:

1. Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.

2. Right-click on the Server, then select Properties. Under the Replication tab, choose Configure for Publishing and Distribution.

3. At this point, if you receive a message that states SQL Server replication does not support nicknames, then perform these steps:

   1. Go back to the server name (probably called local), and right-click Delete SQL Server Registration.

   2. Right-click on the SQL-Group, then select New SQL Server Registration and add the name of the Unity server.

   If you do not receive an error message, go to step 4.

4. Click Next. In the next window, choose the Make <Servername> it's own distributor; SQL server will create a distribution database and log radio button.

5. Click Next until you see the Customize the Configuration window. Choose use the default settings and click Next.

6. Click Finish. You receive a message that states SQL Server Enterprise Manager successfully enabled <servername> as the distributor for <servername>. Click OK and then Close.

Solution 2

This issue can also occur when the SQL Server is renamed after it was originally installed. Therefore, the SQL Server name (old server name) does not match the new machine name (new server name) as mentioned in Unity Failover Error Messages. In order to resolve the issue, perform the steps mentioned in the Problem Description and Workaround sections under ODBC Error: Could not change the Publisher because the subscription has been dropped.

Verify

In order to verify, run the query exec sp_dboption 'UnityDb','published',false in the SQL Query Analyzer. There should not be any error messages that appear. You can run the Cisco Unity Failover Configuration Wizard successfully now.

Note: If the wizard fails again with the error [SQL-DMO]Invalid to alter this property after the distributor has been installed in the diag-failoverconfig.txt, you need to disable any Antivirus application running on the server and then run the wizard again.

Cisco Support Community - Featured Conversations

Related Information

• Voice Technology Support
• Voice and Unified Communications Product Support
• Recommended Reading: Troubleshooting Cisco IP Telephony
• Technical Support & Documentation - Cisco Systems