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


The information in this article applies to:

  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Developer Edition
This article was previously published under Q302491

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 ####

Modification Type:MinorLast Reviewed:4/7/2006
Keywords:kbtshoot kbprb KB302491 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.