Cisco Unity Troubleshooting Guide (With Microsoft Exchange), Release 4.0(4)

Table Of Contents


Troubleshooting SQL Replication


Problems and troubleshooting procedures specific to failover are described in this chapter.

Troubleshooting SQL Replication

While running the failover configuration wizard, the following error may appear:

Configure Cisco Unity Failover Wizard - [0x80044833]
[Microsoft][ODBC SQL Server Driver][Sql Server]Could not connect to server
"<new_server_name>" because `distributor_admin' is not defined as a remote login
at the server.

This error occurs when the SQL Server was renamed after it was originally installed, and therefore the SQL Server name (old server name) does not match the machine name (new server name). To change the SQL Server name (old) to match the machine name (new), do the following "To Change the SQL Server Name" procedure.

Note Before doing this procedure, you must log on to the server with sufficient permission to change the database.

To Change the SQL Server Name

Step 1 On the Windows Start menu, click Programs > Microsoft SQL Server > Query Analyzer.

Step 2 In the Connect to SQL Server dialog box, enter the following settings:

a. In the SQL Server field, enter the name of the Cisco Unity server.

b. Under Connect Using, click Windows Authentication.

Then click OK.

Step 3 In the SQL Query Analyzer window, enter select @@servername, press Enter, and click the Execute Query button. The lower pane of the window displays the old server name, which you will enter in Step 4.

Step 4 Enter exec sp_dropserver '<Old_server_name>', where <Old_server_name> is the name you found in Step 3, and press Enter. Note that you must use single quotation marks as shown.

Step 5 Enter exec sp_addserver '<new_server_name>', 'local', and press Enter. Note that you must use single quotation marks as shown.

Step 6 Click the Execute Query button.

Step 7 In the system tray, right-click the MSSQLServer icon, and click MSSQLServer - Stop.

Step 8 When prompted to confirm stopping the MSSQLServer service, click Yes.

Step 9 When prompted to confirm stopping all dependent services, click Yes.

Step 10 In the AvCsTrayStatus dialog box, click OK.

Step 11 When the MSSQLServer icon indicates that the SQL Server has restarted, in the Query window, select the line select @@servername, and click the Execute Query button to verify the new server name.

Step 12 Close the SLQ Query Analyzer window.

Step 13 In the system tray, right-click the Cisco Unity icon, and click Start Unity.