DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 302491 - Last Review: January 16, 2015 - Revision: 5.0

This article has been archived. It is offered "as is" and will no longer be updated.
This article has been archived. It is offered "as is" and will no longer be updated.

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


Applies to
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
Keywords: 
kbnosurvey kbarchive kbtshoot kbprb KB302491
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support