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

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.

Back to the top

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.

Back to the top

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.

Back to the top

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

Back to the top