SQL Server 2000 Cluster Setup may fail to perform required operations on the cluster nodes when special characters are used in the resource name

Article translations Article translations
Article ID: 302491 - View products that this article applies to.
This article was previously published under Q302491
Expand all | Collapse all

SYMPTOMS

During the installation of a SQL Server 2000 virtual server in a clustered environment, if some of the resources have special characters in their name, the installation may fail with the following error message:
Setup failed to perform required operations on the cluster nodes.

CAUSE

The error message occurs if any of the cluster resources have special characters, like the following, in their names:
  • >
  • <
  • "
  • '
  • &
  • (, )
  • +
  • Characters with a dieresis, a tilde, or a space character.

WORKAROUND

To work around this problem, follow these steps:
  • Change the name of the resources.
  • Use uppercase letters.
  • Avoid using special characters.
  • Avoid using spaces in the names of the cluster resources (network connections, group names, network adapters, and more, for example).
  • Use all uppercase or all lowercase letters for the network connections.
  • Avoid using the same name for the SQL Server groups and the SQL Server virtual network names.
Note Review the Sqlstp#.log files to check and see what resource is causing the error.

MORE INFORMATION

Review the following files for more detail.

sqlstp#.log
*********************
19:18:32 [DlgVirtServer]
19:18:32 Result = 1
19:18:32 VirtServerName = SQLVirtualName
19:18:32 IpAddresses = X.X.X.X,255.255.255.0, LAN (Local Area Network)
				
Because the name contains parenthesis and spaces, change the name of the public network connection to LAN or PUBLIC to avoid the problem:
19:18:32 ShowDlgVirtualServer returned: -1
19:18:32 ShowDlgVirtualServer: GetLastError returned: 87
19:18:32 The parameter is incorrect.


sqlstp.log
***********************
[Server.2]
NumRemoteServices=1
1.app=\\NODE1\E$\CDSQL~1\x86\setup\setupsql.exe
1.server=NODE2
1.script=\\NODE1\admin$\NODE2_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f 
"\\NODE1\E$\CDSQL~1\x86\setup\setup.ins" -f1 %s -f2 "\\NODE2\admin$\setup.log" -e "stpsilnt._ex"  -x "C:\"
1.user=DOMAIN\NTACCOUNT
1.password=PASSWORD
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
19:18:30 Setup is performing required operations on cluster nodes.  This may take a few minutes...
19:18:30  C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
19:19:25 Process Exit Code: (2) The system cannot find the file specified.

19:19:25 Begin Action : GetRemsetupRetCode
19:19:25 Installation return status on NODE1 : 2
19:19:25 Installation return status on NODE2 : 2
19:19:25 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time MM/DD/YY HH:MM:SS ####
				

Properties

Article ID: 302491 - Last Review: April 7, 2006 - Revision: 4.4
APPLIES TO
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
Keywords: 
kbtshoot kbprb KB302491

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com