SQL SP4 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 2008 Forums

SQL Server Administration (2008)

SQL SP4 Failed

Author

Topic

stegib
Starting Member

16 Posts

Posted - 2012-06-07 : 12:41:58

Can you help me with this?
Setup failed to perform required operations on the clustered nodes" - SP4 install on failover node

I added two new nodes to our existing Windows 2003 Enterprise SQL2000 Cluster with the setup in advance mode selecting to maintain cluster failover option. They added ok and are in all the cluster resources as owners. When I try to apply SP4 on the new node I get this message. Setup failed to perform required operations on the clustered nodes" - SP4 install on failover node

The original nodes both have SP4 on them.

I first had this error and applied the hotfix.. http://support.microsoft.com/kb/905286
I was then able to continue.
Then I tried applying SP4 after applying this hotfix.. http://support.microsoft.com/kb/914839
I still cannot apply SP4. Setup still fails.

Please reply to me by email.. stegib@stcroixcasino.com

Sachin.Nand

2937 Posts

Posted - 2012-06-07 : 23:57:07

Did you check the error log for the exact error message?

After Monday and Tuesday even the calendar says W T F ....

stegib
Starting Member

16 Posts

Posted - 2012-06-08 : 07:50:15

quote:
Originally posted by Sachin.Nand

Did you check the error log for the exact error message?

After Monday and Tuesday even the calendar says W T F ....

Where is the error log located at?

Sachin.Nand

2937 Posts

Posted - 2012-06-08 : 10:17:15

Its at the default location where SQL Binaries are installed.Something like this for SQL Server 2008R2

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log.

Also you might want to check C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log and then in the most recent folder there's a Detail.txt file.

You can search for "error" and\or "warning" for the exact error.

After Monday and Tuesday even the calendar says W T F ....

stegib
Starting Member

16 Posts

Posted - 2012-06-08 : 11:03:20

I found it in Windows.. This is the log..
07:08:12 Begin Setup
07:08:12 Version on Media: 8.00.2183
07:08:12 Mode = Normal
07:08:12 ModeType = NORMAL
07:08:12 Loading library - sqlsut.dll (#L1)
07:08:12 Begin: SetupInitialize()
07:08:12 End: SetupInitialize()
07:08:12 Begin: CheckFixedRequirements()
07:08:12 Platform ID: 0xf00000
07:08:12 Version: 5.2.3790
07:08:12 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.4969
07:08:12 End: CheckFixedRequirements()
07:08:12 Processor Architecture: x86 (Pentium)
07:08:12 Service Pack: 512
07:08:12 ComputerName: TLC-OASIS1
07:08:12 User Name: tlcbackup
07:08:12 IsAllAccessAllowed returned: 1
07:08:12 OS Language: 0x409
07:08:12 Begin: SetupInstall()
07:08:12 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
07:08:12 CommonFilesDir=C:\Program Files\Common Files
07:08:12 Windows Directory=C:\WINDOWS07:08:12 Program Files=C:\Program Files07:08:12 TEMPDIR=C:\DOCUME~1\TLCBAC~1\LOCALS~1\Temp07:08:12 End: SetupInstall()
07:08:13 Begin: ShowDialogs()
07:08:13 Initial Dialog Mask: 0x8300037, Disable Back=0x1
07:08:13 Begin Action ShowDialogsHlpr: 0x1
07:08:13 Begin Action: DialogShowSdWelcome
07:08:15 End Action DialogShowSdWelcome
07:08:15 Dialog 0x1 returned: 1
07:08:15 End Action ShowDialogsHlpr
07:08:15 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
07:08:15 Begin Action ShowDialogsHlpr: 0x2
07:08:15 Begin Action: DialogShowSdMachineName
07:08:24 ShowDlgMachine returned: 1
07:08:24 Name = TLCATISQL, Type = 0x20000008
07:08:24 End Action DialogShowSdMachineName
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
07:08:24 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
07:08:24 Dialog 0x2 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
07:08:24 Begin Action ShowDialogsHlpr: 0x4
07:08:24 Begin Action: DialogShowSdInstallMode
07:08:24 g_nInstallMode : 32
07:08:24 ShowDlgInstallMode returned: 1
07:08:24 InstallMode : 0x20
07:08:24 End Action DialogShowSdInstallMode
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
07:08:24 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
07:08:24 Dialog 0x4 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
07:08:24 Begin Action ShowDialogsHlpr: 0x8
07:08:24 Begin Action : DialogShowSdAdvanced
07:08:24 g_bNeedSpKey
07:08:24 ShowDlgAdvanced returned: 1
07:08:24 Adv Install Mode = -2147483648
07:08:24 End Action : DialogShowSdAdvanced
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
07:08:24 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:24 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
07:08:24 Dialog 0x8 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
07:08:24 Begin Action ShowDialogsHlpr: 0x4000
07:08:24 Skipping DialogShowSdVirtualServer
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
07:08:24 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:24 Updated Dialog Mask: 0x3c003, Disable Back = 0x1
07:08:24 Dialog 0x4000 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
07:08:24 Begin Action ShowDialogsHlpr: 0x8000
07:08:24 Begin Action : DialogShowSdDiskGroups
07:08:24 ShowDlgDiskGroups returned: 1
07:08:24 Disk Group = SQL
07:08:24 End Action : DialogShowSdDiskGroups
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0x3c003, nCurrent = 0x8000, nDirection = 1
07:08:24 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:24 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
07:08:24 Dialog 0x8000 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
07:08:24 Begin Action ShowDialogsHlpr: 0x10000
07:08:24 Begin Action: DialogShowSdClusterDef
07:08:24 Before !! The Prefowner list is : . g_szSpNeededNodelst is :TLC-OASIS1,TLC-OASIS2 . g_nNumnodes :0 g_szOwners :, g_szDiskGroup SQL
07:08:24 ShowDlgClusterDef returned: 1
07:08:24 PrefOwners = TLC-OASIS1,TLC-OASISSVR1,TLC-OASISSVR2,TLC-OASIS2,TLC-OASIS1,TLC-OASIS2, NumIp = 6
07:08:24 Begin Action : ValidateNodeActions
07:08:24 Begin Action : EnumerateInstancesForVirtualServer
07:08:24 End Action : EnumerateInstancesForVirtualServer
07:08:24 Begin Action : ValidateNodeActions
07:08:24 End Action : ValidateNodeActions
07:08:24 End Action : ValidateNodeActions
07:08:24 End Action DialogShowSdClusterDef
07:08:24 begin ShowDialogsUpdateMask
07:08:24 nFullMask = 0x3c00f, nCurrent = 0x10000, nDirection = 1
07:08:24 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:24 Updated Dialog Mask: 0x4fc00f, Disable Back = 0x1
07:08:24 Dialog 0x10000 returned: 1
07:08:24 End Action ShowDialogsHlpr
07:08:24 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
07:08:24 Begin Action ShowDialogsHlpr: 0x20000
07:08:24 Begin Action : Cluster Security - DlgAcct
07:08:34 ShowDlgAcct returned: 1
07:08:34 [DlgAccount]
07:08:34 Domain = STCROIX
07:08:34 DomainAcct = TLCBACKUP
07:08:34 Result = 1
07:08:34 End Action : Cluster Security - DlgAcct
07:08:34 begin ShowDialogsUpdateMask
07:08:34 nFullMask = 0x4fc00f, nCurrent = 0x20000, nDirection = 1
07:08:34 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:34 Updated Dialog Mask: 0x4e400f, Disable Back = 0x1
07:08:34 Dialog 0x20000 returned: 1
07:08:34 End Action ShowDialogsHlpr
07:08:34 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
07:08:34 Begin Action ShowDialogsHlpr: 0x40000
07:08:34 Begin Action: DialogShowSdCliSvr
07:08:34 ShowDlgClientServerSelect returned: 1
07:08:34 Type : 0x2
07:08:34 End Action DialogShowSdCliSvr
07:08:34 begin ShowDialogsUpdateMask
07:08:34 nFullMask = 0x4e400f, nCurrent = 0x40000, nDirection = 1
07:08:34 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:34 Updated Dialog Mask: 0x5fc00f, Disable Back = 0x1
07:08:34 Dialog 0x40000 returned: 1
07:08:34 End Action ShowDialogsHlpr
07:08:34 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
07:08:34 Begin Action ShowDialogsHlpr: 0x80000
07:08:34 Begin Action: DialogShowSdInstanceName
07:08:34 Begin Action: Enumerate Instances for Virtual Server
07:08:34 End Action: Enumerate Instances for Virtual Server
07:08:34 Begin Action: Set Maintenance Mode Information
07:08:34 CreateSetupTopology(TLCATISQL), Handle : 0x16e5028, returned : 0
07:08:34 CreateSetupTopology returned : 0, Handle : 0x16e5028
07:08:34 Topology Type : 2, Return Value : 0
07:08:34 ST_GetPhysicalNode returned : 0, PNHandle : 0x16e59b8
07:08:34 PN_EnumerateEx returned : 0
07:08:34 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
07:08:34 PN_GetInstance for MSSQLSERVER [0x16e59b8] returned : 0
07:08:34 SQLI_GetPackageId [0x16e5078] returned : 0, PackageId = 0x3
07:08:34 SQLI_GetVersion [0x16e5078] returned : 0, Version = 8.00.194
07:08:34 SQLI_GetSQLStates for MSSQLSERVER [0x16e5078] returned : 0, SQLStates: 0x400209
07:08:34 SQLI_GetInstallPath [0x16e5078] returned : 0, Path = \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server\MSSQL
07:08:34 SQLI_GetDataPath [0x16e5078] returned : 0, DataPath = \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server\MSSQL
07:08:34 SQLI_GetVersion [0x16e5078] returned : 0, Version = 8.00.194
07:08:34 SQLI_GetRegKeyRoot [0x16e5078] returned : 0, RegKeyRoot = Software\Microsoft\MSSQLServer
07:08:34 SQLI_GetPackageName [0x16e5078] returned : 0, szPackage = Enterprise Edition
07:08:34 SQLI_GetPackageId [0x16e5078] returned : 0, PackageId = 0x3
07:08:34 Previous Install Path: \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server\MSSQL
07:08:34 Previous Install Data: \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server\MSSQL
07:08:34 Previous Install Version: 8.00.194
07:08:34 ReleaseSetupTopology
07:08:34 End Action: Set Maintenance Mode Information
07:08:34 ShowDlgInstanceName returned : 1
07:08:34 InstanceName : MSSQLSERVER
07:08:34 End Action DialogShowSdInstanceName
07:08:34 begin ShowDialogsUpdateMask
07:08:34 nFullMask = 0x5fc00f, nCurrent = 0x80000, nDirection = 1
07:08:34 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:34 Updated Dialog Mask: 0x5fc00f, Disable Back = 0x1
07:08:34 Dialog 0x80000 returned: 1
07:08:34 End Action ShowDialogsHlpr
07:08:34 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
07:08:34 Begin Action ShowDialogsHlpr: 0x100000
07:08:34 Begin Action: DialogShowSdSetupType
07:08:34 Begin Action: Setup Type
07:08:34 [SetupTypeSQL]
07:08:34 szDir = \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server
07:08:34 szDir = \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server
07:08:34 Result = 1
07:08:34 szDataDir = \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server
07:08:34 szDataDir = \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server
07:08:34 End Action: Setup Type
07:08:34 Setup Type: Typical (301)
07:08:35 End Action DialogShowSdSetupType
07:08:35 begin ShowDialogsUpdateMask
07:08:35 nFullMask = 0x5fc00f, nCurrent = 0x100000, nDirection = 301
07:08:35 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:35 Updated Dialog Mask: 0x5fc00f, Disable Back = 0x1
07:08:35 Dialog 0x100000 returned: 301
07:08:35 End Action ShowDialogsHlpr
07:08:35 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
07:08:35 Begin Action ShowDialogsHlpr: 0x400000
07:08:35 Begin Action: DlgServices
07:08:45 ShowDlgServices returned: 1
07:08:45 [DlgServices]
07:08:45 Local-Domain = 61680
07:08:45 AutoStart = 0
07:08:45 SQLDomain = STCROIX
07:08:45 SQLDomainAcct = TLCBACKUP
07:08:45 AgtDomain = STCROIX
07:08:45 AgtDomainAcct = TLCBACKUP
07:08:45 Result = 1
07:08:45 End Action DlgServices
07:08:45 begin ShowDialogsUpdateMask
07:08:45 nFullMask = 0x5fc00f, nCurrent = 0x400000, nDirection = 1
07:08:45 *g_nAdvInstallMode is INSTALLMODE_MODVIRTSERVER *
07:08:45 Updated Dialog Mask: 0x43c00f, Disable Back = 0x1
07:08:45 Dialog 0x400000 returned: 1
07:08:45 End Action ShowDialogsHlpr
07:08:45 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
07:08:45 End: ShowDialogs()
07:08:45 Initializing Event Log
07:08:45 Begin Action : LogEvent
07:08:45 End Action : LogEvent
07:08:46 Begin Action : ClusterSetupHelper
07:08:46 Begin Action : CreateClustISSFiles
07:08:46 End Action : CreateClustISSFiles
07:08:46 Begin Action : ClusterWriteRemIni
07:08:46 CreateSetupTopology(TLCATISQL), Handle : 0x16e5028, returned : 0
07:08:46 CreateSetupTopology returned : 0, Handle : 0x16e5028
07:08:46 Topology Type : 2, Return Value : 0
07:08:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x16e59b8
07:08:46 PN_EnumerateEx returned : 0
07:08:46 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
07:08:46 PN_GetInstance for MSSQLSERVER [0x16e59b8] returned : 0
07:08:46 SQLI_GetPackageId [0x16e5078] returned : 0, PackageId = 0x3
07:08:46 SQLI_GetVersion [0x16e5078] returned : 0, Version = 8.00.194
07:08:46 SQLI_GetSQLStates for MSSQLSERVER [0x16e5078] returned : 0, SQLStates: 0x400209
07:08:46 SQLI_GetInstallPath [0x16e5078] returned : 0, Path = \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server\MSSQL
07:08:46 SQLI_GetDataPath [0x16e5078] returned : 0, DataPath = \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server\MSSQL
07:08:46 SQLI_GetVersion [0x16e5078] returned : 0, Version = 8.00.194
07:08:46 SQLI_GetRegKeyRoot [0x16e5078] returned : 0, RegKeyRoot = Software\Microsoft\MSSQLServer
07:08:46 SQLI_GetPackageName [0x16e5078] returned : 0, szPackage = Enterprise Edition
07:08:46 SQLI_GetPackageId [0x16e5078] returned : 0, PackageId = 0x3
07:08:46 Previous Install Path: \\TLC-OASISSVR1\C$\Program Files\Microsoft SQL Server\MSSQL
07:08:46 Previous Install Data: \\TLC-OASISSVR1\S$\Program Files\Microsoft SQL Server\MSSQL
07:08:46 Previous Install Version: 8.00.194
07:08:46 ReleaseSetupTopology
07:08:47 End Action : ClusterWriteRemIni
07:08:47 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=1
Server.1=TLC-OASIS2
[Server.1]
NumRemoteServices=1
1.app="\\TLC-OASIS1\C$\SQL2KSP4\x86\setup\setupsql.exe"
1.server=TLC-OASIS2
1.script=\\TLC-OASIS1\admin$\TLC-OASIS2_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\TLC-OASIS1\C$\SQL2KSP4\x86\setup\setup.ins" -f1 %s -f2 "\\TLC-OASIS2\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=STCROIX\TLCBACKUP
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
07:08:47 Setup is performing required operations on cluster nodes. This may take a few minutes...
07:08:47 "C:\DOCUME~1\TLCBAC~1\LOCALS~1\Temp\SqlSetup\Bin\remsetup.exe" C:\WINDOWS\remsetup.ini
07:14:22 Process Exit Code: (-12)
07:14:22 Begin Action : GetRemsetupRetCode
07:14:22 Installation return status on TLC-OASIS2 : -12
07:14:22 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 06/08/12 07:08:47 ####

CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x10c] created for execution.
CThreadPool::RunUntilCompleteHlpr start thread [0x10c],index=0
CThread::Process [0x10c]
Script file copied to '\\TLC-OASIS2\ADMIN$\TLC-OASIS2_MSSQLSERVER.iss' successfully.

Installing remote service (TLC-OASIS2)...

CRemoteProcess::RunUntilComplete [0x10c] exit code: -12
Remote process exit code was '-12' (TLC-OASIS2).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x10c]
Thread [0x10c] exit code: [0xfffffff4]
CThreadPool::RunUntilComplete returned -12
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.

Disconnecting from remote machine (TLC-OASIS2)...

Service removed successfully.

Remote files removed successfully.

#### SQL Server Remote Setup - Stop Time 06/08/12 07:14:22 ####

07:14:22 End Action : Run setup on cluster nodes
07:14:22 One or more errors occurred while running remote setup on the clustered machines.
07:14:31 Setup failed to perform required operations on the cluster nodes.
07:14:31 Begin Action : ClusterErrorCleanup
07:14:31 End Action : ClusterErrorCleanup
07:14:31 End Action : ClusterSetupHelper
07:14:31 Begin Action : LogEvent
07:14:31 End Action : LogEvent
07:14:31 Begin Action : CloseEventLog
07:14:31 End Action : CloseEventLog

The Windows Application log shows this about the same time SP4 failed.
The data portion of event 17052 from MSSQLSERVER is invalid. Event 322

Sachin.Nand

2937 Posts

Posted - 2012-06-08 : 13:17:19

I think this where the error is

Remote process exit code was '-12' (TLC-OASIS2).

Found a KB for the same.

http://support.microsoft.com/kb/321063

After Monday and Tuesday even the calendar says W T F ....

Sachin.Nand

2937 Posts

Posted - 2012-06-08 : 13:19:43

Also log into the nodes under domain admin account and then try running the set up.

After Monday and Tuesday even the calendar says W T F ....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-08 : 13:28:52

Well make sure no one is logged into the other node, and I mean no one, not even you. And make sure that you are the only one logged into the current node.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

stegib
Starting Member

16 Posts

Posted - 2012-06-09 : 17:29:03

Just be logged off the nodes that need to have SP4 installed? That is tlc-oasis2. I need to update tlc-oasis1 and tlc-oasis2. The original nodes in the cluster both have SP4 installed. Or should I completely log off from all cluster nodes and apply SP4 on one of the nodes then log off that one and then apply to the other? How will it effect the Virtual SQL server that is running on the active node that already has SP4 installed?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-09 : 19:13:09

Yes you need to logoff the other node while applying it on the first node. No one can be logged into the cluster but you on a single node.

The other instance will not be impacted, assuming it's on the other node.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

stegib
Starting Member

16 Posts

Posted - 2012-06-10 : 09:41:49

My two original nodes are active passive.. Tlc-oasissrv1 and tlc-oasissrv2.. these both have SP4 on them.. The new ones are tlc-oasis1 and tlc-oasis2 with NO SP4 installed on them. So you are saying log off ALL nodes then try the setup again on one of the new ones then the other new one. This will just update the binaries on the new nodes correct and do nothing to the virtual SQL server? Or just log off on the new nodes? The error message on the setup logs only show the new nodes.

Why is setup failing? Authentication? I am using a Domain Admin account.

Sachin.Nand

2937 Posts

Posted - 2012-06-10 : 12:34:04

quote:
Originally posted by stegib

...Why is setup failing? Authentication? I am using a Domain Admin account.

Did you check the KB I had posted earlier ?

http://support.microsoft.com/kb/321063

After Monday and Tuesday even the calendar says W T F ....

stegib
Starting Member

16 Posts

Posted - 2012-06-10 : 19:15:03

Yes I did but it mostly applies the the SQL setup on newly added cluster servers. That process went find,, just having problems with SP4 on the new nodes. I know I can not fail over to them unless they have SP4 installed on them because the original servers have it already. Clusters and Networks I understand but this SQL stuff I am such a newbie and trying to understand it. I know some things but I am having problems understanding why such an easy operation is failing. The only thing that keeps coming to my mind is a permission thing. I use a Domain Admin account to log into the servers with Dameware.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-10 : 22:42:46

Well you can failover to the other node without installing SP4. I've got an issue on one of my clusters where one node has the service pack and the other doesn't. Been meaning to fix it, just haven't found the time to call Microsoft.

And with 2008, you patch the passive node to avoid downtime. Then do the failover, then patch the new passive node.

I'd suggest opening a case with Microsoft to resolve the issue. I'm constantly having to do that for SQL installations (base installation, service packs, hotfixes, you name it).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

stegib
Starting Member

16 Posts

Posted - 2012-06-11 : 07:24:27

I am on Windows 2003R2 Enterprise

I logged of all nodes except the one I was patching,, No success, still same error....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-11 : 12:45:19

Call Microsoft.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

stegib
Starting Member

16 Posts

Posted - 2012-06-13 : 09:40:15

Backup Registry before any changes are made.. Here is the fix that worked for me with a Microsoft call.

Check nslookup on both new nodes to Virtual SQL Server Instance. Ok
Ping Virtual Server Instance on both new nodes. Ok
Check registry key: local machine / software / Microsoft / non-driver-signing policy = 00
On both new nodes that SP4 failed. Check registry key: local machine / software / Microsoft / Microsoft SQL Server / 80 .. if Need_sp_Key is there rename key on one node and start the install of SP4 on other node / reboot.
After successful install go back to the node that you renamed the key and rename it back to its original name / start the SP4 install, reboot server. Check the registry on both new nodes and the key need-sp_key should be gone. That key will not be on the active / passive nodes.
Now check the SQL build on all Nodes.
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Sqlservr.exe and sqlagent.exe
Build needs to be the same on all nodes. If not then download the hotfix and apply to the Active node which will update all nodes to current level. After install you will need to reboot all nodes.
http://www.microsoft.com/en-us/download/details.aspx?id=22831
SQL2000-KB916287-v8.00.2187-x86x64-ENU.exe

No need to be logged off any node during installation. You can be logged into all nodes.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources