SP upgrade failed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SP upgrade failed

Author

Topic

ckleong
Starting Member

17 Posts

Posted - 2009-06-06 : 20:51:29

Hi,
I am upgrading SQL 2000 sp3 to sp4. There is a two nodes cluster. By right, i should only run the SP on active node, and it will transfer the necessary files install to passive node.

During the upgrade, i have encounter an error "setup is failed to performing required operation on cluster node". When i checked the log, it shown the files cannot get transfer to passive node and the log files not created in passive node. I have attached part of the log(active node) here. Please focus on the Process Exit Code.

I also look for google help and it is mention on the terminal server problem. But my server didn install terminal server. So, please share your solution to me. Thanks

Rick

LOG
===

NumRemoteServices=1
1.app="\\DB210B\D$\src\sql\SQL2000 SP4\x86\setup\setupsql.exe"
1.server=DB210B
1.script=\\DB210B\admin$\DB210B_MSSQLSERVER.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\DB210B\D$\src\sql\SQL2000 SP4\x86\setup\setup.ins" -f1 %s -f2 "\\DB210B\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\DOCUME~1\AGM~1.118\LOCALS~1\Temp\1\"
1.user=ROOT-SCBNET\a.gm.1180692
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app="\\DB210B\D$\src\sql\SQL2000 SP4\x86\setup\setupsql.exe"
1.server=DB210A
1.script=\\DB210B\admin$\DB210A_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\DB210B\D$\src\sql\SQL2000 SP4\x86\setup\setup.ins" -f1 %s -f2 "\\DB210A\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=ROOT-SCBNET\a.gm.1180692
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
11:16:05 Setup is performing required operations on cluster nodes. This may take a few minutes...
11:16:05 "C:\DOCUME~1\AGM~1.118\LOCALS~1\Temp\1\SqlSetup\Bin\remsetup.exe" C:\WINDOWS\remsetup.ini
11:18:50 Process Exit Code: (-1)
11:18:50 Begin Action : GetRemsetupRetCode
11:18:50 Installation return status on DB210B : 0
11:18:50 Installation return status on DB210A : -1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources