Microsoft KB Archive/302491

= 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 ID: 302491

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise 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:
 * &quot;
 * Characters with a dieresis, a tilde, or a space character.
 * &quot;
 * Characters with a dieresis, a tilde, or a space character.
 * Characters with a dieresis, a tilde, or a space character.
 * Characters with a dieresis, a tilde, or a space character.
 * Characters with a dieresis, a tilde, or a space character.
 * 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 &quot;\\NODE1\E$\CDSQL~1\x86\setup\setup.ins&quot; -f1 %s -f2 &quot;\\NODE2\admin$\setup.log&quot; -e &quot;stpsilnt._ex&quot; -x &quot;C:\&quot; 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
 * 1) SQL Server Remote Setup - Start Time MM/DD/YY HH:MM:SS ####

Additional query words: cluster setup sql code quote ampersand parenthesis plus greater than less

Keywords: kbtshoot kbprb KB302491

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.