This document provides a description and resolution for the Microsoft Structured Query Language (SQL) Server error:
The SQL Server server name SQL Server server name does not match the computer
name Your Computer Name.
Cisco recommends that you have knowledge of these topics:
The information in this document is based on these software and hardware versions:
Windows NT 4.0
SQL Server 6.5
All Cisco Intelligent Contact Management (ICM) versions 5.0 and earlier
All ICM servers that contain SQL databases that are necessary for operation
These databases include Loggers and Distributor Admin Workstations (AWs).
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.
Refer to Cisco Technical Tips Conventions for more information on document conventions.
An error occurs which indicates that the SQL Server name does not match the computer name. This sample output from a Logger shows the error:
11:29:37 lb-lgr Trace: The SQL Server server name 'GEODARSSQLA'
does not match the computer name 'GEODARSICMA'
These are the two possible causes:
There has been a change in the name of the machine on which the SQL Server has installation.
There has been an ICM upgrade of an SQL Server but the SQL Server does not have a valid machine name. The name is not valid because SQL Server version 6.5 supports naming conventions that are not identical to SQL Server version 7.0. For example, a name that is valid with version 6.5 can be invalid with version 7.0.
Microsoft states, "The first character must be a letter or an underscore (_). Characters following the first character can include letters, numbers, or the symbols #, $, or _. No embedded spaces are allowed." However, SQL Server can successfully install with a hyphen in the computer name.
As there are two causes of this problem, there are two solutions. If you identify the cause of the problem to be a rename of the SQL Server, the easiest solution is to change the machine name back to the previous name.
If a rename of the machine is not an option, the alternative is to rename the SQL Server with the actual computer name. Complete these steps:
Stop all ICM services on the machine.
Issue these commands:
If an SQL Server has a hyphen in the machine name that you must keep, cycle the SQL Server service for the change to @@SERVERNAME to take effect.