Problem installing SP4

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BruceB - 13 Aug 2005 06:20 GMT

Hi, when attempting to apply SP4 to a SQL cluster, we are getting the
following message.

Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal
state. The program cannot safely continue execution and must now be
terminated.

This happens just after entering the account required to update both cluster
notes. The account is a domain admin account.

Any help greatly appreciated.
BB

Reply to this Message

Uttam Parui[MS] - 15 Aug 2005 15:45 GMT

Hello Bruce,

Verify that there are no dependencies other than those created by the SQL Server setup on any SQL Server cluster resources. Resources such as file shares, FTP servers, and Microsoft Internet Information
Services (IIS) servers must always have a unique network name and an IP address resource. You must remove any such non-default dependencies before you install SQL Server 2000 SP4. No dependencies other
than those supplied by the SQL Server setup must be used, except to validate whether SQL Server is online and available for the client application.

For example, if you have MSDTC resource in the SQL group and if MSDTC is dependent on SQL Server Network Name and SQL IP Address then you may have this issue. If this is the case then you will need to
remove the dependencies and then re-run the setup.

Also, make sure that you have followed the SP4 pre-installation checklist (see link below).

If you still have the same problem, then the next step will be to review the logs. I would start with the sqlsp.log (created on the node where you ran the SP4 setup). You can also cut and paste the log for us to review.

Recommended Reading
======================
SQL Server 2000 Service Pack 3, Service Pack 3a, or Service Pack 4 pre-installation checklist for SQL Server 2000 virtual server for failover clustering
http://support.microsoft.com/?kbid=811168

Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default.aspx?scid=KB;EN-US;254321

Best Regards,

Uttam Parui
Microsoft Corporation

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Reply to this Message

BruceB - 17 Sep 2005 11:19 GMT

Hi,

I checked the dependencies. It doesn't look like anything is dependent on
SQL Server other than SQLAgent which I believe is correct. The only thing
that I think is weird in this setup is that MSDTC is in the cluster quorum
resource group...

Anyway, here is the content of sqlsp.log.

21:41:52 Begin Setup
21:41:52 Version on Media: 8.00.2039
21:41:52 Mode = Normal
21:41:52 ModeType = NORMAL
21:41:52 Loading library - sqlsut.dll (#L1)
21:41:52 Begin: SetupInitialize()
21:41:52 End: SetupInitialize()
21:41:52 Begin: CheckFixedRequirements()
21:41:52 Platform ID: 0xf00000
21:41:52 Version: 5.2.3790
21:41:52 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.327
21:41:52 End: CheckFixedRequirements()
21:41:53 Processor Architecture: x86 (Pentium)
21:41:53 ComputerName: OMF-DBCLUSTER-A
21:41:53 User Name: datacom
21:41:53 IsAllAccessAllowed returned: 1
21:41:53 OS Language: 0x409
21:41:53 Begin: SetupInstall()
21:41:53 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
21:41:53 CommonFilesDir=C:\Program Files\Common Files
21:41:53 Windows Directory=C:\WINDOWS\
21:41:53 Program Files=C:\Program Files\
21:41:53 TEMPDIR=C:\DOCUME~1\datacom\LOCALS~1\Temp\1\
21:41:53 End: SetupInstall()
21:41:53 Begin: ShowDialogs()
21:41:53 Initial Dialog Mask: 0x8300037, Disable Back=0x1
21:41:53 Begin Action ShowDialogsHlpr: 0x1
21:41:53 Begin Action: DialogShowSdWelcome
21:41:56 End Action DialogShowSdWelcome
21:41:56 Dialog 0x1 returned: 1
21:41:56 End Action ShowDialogsHlpr
21:41:56 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
21:41:56 Begin Action ShowDialogsHlpr: 0x2
21:41:56 Begin Action: DialogShowSdMachineName
21:42:02 ShowDlgMachine returned: 1
21:42:02 Name = OMF-DBCLUSTER, Type = 0x20000008
21:42:02 End Action DialogShowSdMachineName
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
21:42:02 Dialog 0x2 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
21:42:02 Begin Action ShowDialogsHlpr: 0x4
21:42:02 Begin Action: DialogShowSdInstallMode
21:42:02 ShowDlgInstallMode returned: 1
21:42:02 InstallMode : 0x2
21:42:02 End Action DialogShowSdInstallMode
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
21:42:02 Dialog 0x4 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
21:42:02 Begin Action ShowDialogsHlpr: 0x200
21:42:02 Begin Action: DialogShowSdInstanceName
21:42:02 Begin Action: ShowDlgInstanceName
21:42:02 SKU is : Enterprise Edition
21:42:02 End Action: ShowDlgInstanceName
21:42:02 ShowDlgInstanceName returned : 0
21:42:02 InstanceName : MSSQLSERVER
21:42:02 End Action DialogShowSdInstanceName
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 0
21:42:02 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
21:42:02 Dialog 0x200 returned: 0
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
21:42:02 Begin Action ShowDialogsHlpr: 0x400
21:42:02 Begin Action: DialogShowSdMaintain
21:42:02 ShowDlgMaintainInstall returned : 1
21:42:02 Type : 0xc
21:42:02 CreateSetupTopology(OMF-DBCLUSTER-A), Handle : 0x12648e0, returned

: 0

21:42:02 CreateSetupTopology returned : 0, Handle : 0x12648e0
21:42:02 Topology Type : 1, Return Value : 0
21:42:02 ST_GetPhysicalNode returned : 0, PNHandle : 0x1264928
21:42:02 PN_EnumerateEx returned : 0
21:42:02 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
21:42:02 PN_GetInstance for MSSQLSERVER [0x1264928] returned : 0
21:42:02 SQLI_GetPackageId [0x1264ec0] returned : 0, PackageId = 0x3
21:42:02 SQLI_GetVersion [0x1264ec0] returned : 0, Version = 8.00.194
21:42:02 SQLI_GetSQLStates for MSSQLSERVER [0x1264ec0] returned : 0,
SQLStates: 0x400209
21:42:02 SQLI_GetInstallPath [0x1264ec0] returned : 0, Path = C:\Program
Files\Microsoft SQL Server\MSSQL
21:42:02 SQLI_GetDataPath [0x1264ec0] returned : 0, DataPath = F:\Program
Files\Microsoft SQL Server\MSSQL
21:42:02 SQLI_GetVersion [0x1264ec0] returned : 0, Version = 8.00.194
21:42:02 SQLI_GetRegKeyRoot [0x1264ec0] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
21:42:02 SQLI_GetPackageName [0x1264ec0] returned : 0, szPackage =
Enterprise Edition
21:42:02 SQLI_GetPackageId [0x1264ec0] returned : 0, PackageId = 0x3
21:42:02 Previous Install Path: C:\Program Files\Microsoft SQL Server\MSSQL
21:42:02 Previous Install Data: F:\Program Files\Microsoft SQL Server\MSSQL
21:42:02 Previous Install Version: 8.00.194
21:42:02 ReleaseSetupTopology
21:42:02 End Action DialogShowSdMaintain
21:42:02 begin ShowDialogsUpdateMask
21:42:02 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
21:42:02 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:42:02 Dialog 0x400 returned: 1
21:42:02 End Action ShowDialogsHlpr
21:42:02 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
21:42:02 Begin Action ShowDialogsHlpr: 0x2000
21:42:02 Begin Action: DialogShowSdUpgrade
21:42:02 ShowDlgUpgrade returned : 1
21:42:02 Checking databases on instance 'MSSQLSERVER'
21:42:02 Begin Action: Check for VS Node
21:42:02 Begin Action: Check for VS Node
21:42:02 Begin Action: Cluster Resources Offline
21:42:06 End Action: Cluster Resources Offline
21:42:06 Authenticate access
21:42:06 Begin SDPassword Dialog
21:42:09 End SDPassword Dialog
21:42:09 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent 1
-Action 6 -Service MSSQLSERVER
21:42:09 Process Exit Code: (0)
21:42:09 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent 1
-Action 1 -Service MSSQLSERVER -StartupOptions \-T4022
21:42:30 Process Exit Code: (0)
21:42:30 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -d master -Q
"exit" -o "C:\DOCUME~1\datacom\LOCALS~1\Temp\1\sqlsp.out" -E
21:42:30 Process Exit Code: (0)
21:42:30 Begin: CheckSAPassword
21:42:30 Begin: LogOnUsingBlankSA
21:42:30 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -d master -o
"C:\DOCUME~1\datacom\LOCALS~1\Temp\1\sqlsp.out" -Q"Exit(declare @ret int if
(select count(*) from master..syslogins where name='sa' AND ( (1 = pwd
21:42:30 Process Exit Code: (0)
21:42:30 End: LogOnUsingBlankSA
21:42:30 Begin: SdBlankPwd
21:42:30 End: SdBlankPwd
21:42:30 End: CheckSAPassword
21:42:30 Begin : SdErrorReportingDlg
21:45:02 End: SdErrorReportingDlg
21:45:02 Access authenticated
21:45:02 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:OMF-DBCLUSTER -n -b -d master
-o "C:\DOCUME~1\datacom\LOCALS~1\Temp\1\~sqldb0.txt" -i
"C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\dbverify.sql" -E
21:45:02 Process Exit Code: (0)
21:45:02 C:\DOCUME~1\datacom\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent 1
-Action 6 -Service MSSQLSERVER
21:45:17 Process Exit Code: (0)
21:45:18 Setup Type: Custom (303)
21:45:18 Processing: SQLProg
21:45:18 Processing: SQLProg\SQLServr
21:45:18 Processing: SQLProg\UpgTools
21:45:18 Processing: SQLProg\ReplSupp
21:45:18 Processing: SQLProg\Install
21:45:18 Processing: SQLProg\System
21:45:18 Processing: SQLProg\SvrExt
21:45:18 Processing: SQLProg\Dat
21:45:18 Processing: SQLProg\DatSmpl
21:45:18 Processing: SQLProg\BaseSys
21:45:18 Processing: SQLProg\BaseBinn
21:45:18 Processing: SQLProg\MSSearch
21:45:18 Processing: SQLProg\BaseInst
21:45:18 Processing: SQLProg\UI
21:45:18 Processing: SQLProg\Symbols
21:45:18 Processing: SQLProg\Perfmon
21:45:18 Processing: SQLProg\Root
21:45:18 Processing: SQLProg\EXE
21:45:18 Processing: SQLProg\DLL
21:45:18 Processing: MgtTool
21:45:18 Processing: MgtTool\SEM
21:45:18 Processing: MgtTool\Profiler
21:45:18 Processing: MgtTool\Qryanlz
21:45:18 Processing: MgtTool\DTCCLi
21:45:18 Processing: MgtTool\Wzcnflct
21:45:18 Processing: MgtTool\UtilSys
21:45:18 Processing: MgtTool\UtilBinn
21:45:18 Processing: Connect
21:45:18 Processing: Connect\ConnSys
21:45:18 Processing: Books
21:45:18 Processing: Books\Bookso
21:45:18 Processing: DevTools
21:45:18 Processing: DevTools\Headers and Libraries
21:45:18 Processing: DevTools\MDAC SDKs
21:45:18 Processing: DevTools\VDI
21:45:18 Processing: DevTools\Dbg Int
21:45:18 Processing: Samples
21:45:18 Processing: Samples\ADO
21:45:18 Processing: Samples\DBLIB
21:45:18 Processing: Samples\Desktop
21:45:18 Processing: Samples\DTS
21:45:18 Processing: Samples\ESQLC
21:45:18 Processing: Samples\Misc
21:45:18 Processing: Samples\MSDTC
21:45:18 Processing: Samples\ODBC
21:45:18 Processing: Samples\ODS
21:45:18 Processing: Samples\OLEAut
21:45:18 Processing: Samples\Repl
21:45:18 Processing: Samples\SilverstoneDB
21:45:18 Processing: Samples\SQLDMO
21:45:18 Processing: Samples\SQLNS
21:45:18 Processing: Samples\Utils
21:45:18 Processing: Samples\XML
21:45:18 Processing: CoreRepl
21:45:18 Processing: CoreRepl\Res1033
21:45:18 Processing: CoreRepl\ResIntl
21:45:18 Processing: Core
21:45:18 Processing: Core\Res1033
21:45:18 Processing: Core\ResOther
21:45:18 Processing: Repostry
21:45:18 Processing: Repostry\RepstSys
21:45:18 Processing: Repostry\Res1033
21:45:18 Processing: Repostry\ResIntl
21:45:18 Processing: CoreMisc
21:45:18 Processing: CoreMisc\ActiveX
21:45:18 Processing: CoreMisc\Res1033
21:45:18 Processing: Monarch
21:45:18 Processing: Monarch\Monr1033
21:45:18 Processing: Monarch\MonrIntl
21:45:18 Processing: Jet
21:45:18 Processing: CoreInst
21:45:18 Processing: CoreCOM
21:45:18 Processing: CoreCOM\Res1033
21:45:18 Processing: CoreCOM\ResIntl
21:45:18 Processing: CoreTool
21:45:18 Processing: CoreTool\Res1033
21:45:18 Processing: CoreTool\ResOther
21:45:18 Processing: DBLibCli
21:45:18 Processing: SFExt
21:45:18 Processing: SFExt\ActiveX
21:45:18 Processing: SFExt\Res1033
21:45:18 Processing: SFExt\ResIntl
21:45:18 Processing: Trace
21:45:18 Processing: Trace\Res1033
21:45:18 Processing: Trace\ResOther
21:45:18 Processing: CnctBinn
21:45:18 Processing: MiscCore
21:45:18 Processing: MC
21:45:18 Processing: MC\MC1033
21:45:18 Processing: MC\MCIntl
21:45:18 Processing: MC\Help
21:45:18 Processing: UI
21:45:18 Processing: UI\UIHlp
21:45:18 Processing: UI\UI1033
21:45:18 Processing: UI\UIIntl
21:45:18 Processing: ClstSys
21:45:18 Processing: SQLMgr
21:45:18 Processing: SQLMgr\Res1033
21:45:18 Processing: SQLMgr\ResIntl
21:45:18 Processing: SvrTool
21:45:18 Processing: SvrTool\Res1033
21:45:18 Processing: SvrTool\ResIntl
21:45:18 Processing: DTSUI
21:45:18 Processing: DTSUI\Res1033
21:45:18 Processing: DTSUI\ResIntl
21:45:18 Processing: ClFTSys
21:45:18 Processing: ClFtdata
21:45:18 Processing: MSOlap
21:45:18 Processing: MSOlap\Res1033
21:45:18 Processing: MSOlap\ResIntl
21:45:18 Processing: ATL
21:45:18 Processing: ATL\winnt
21:45:18 Processing: ATL\win9x
21:45:18 Processing: MFC42U
21:45:18 Processing: VC
21:45:18 Processing: VB
21:45:18 Processing: OCX1
21:45:18 Processing: SQLAdHlp
21:45:18 Processing: SQLAdHlp\Res1033
21:45:18 Processing: SQLAdHlp\ResOther
21:45:18 Setup type: Custom
21:45:18 End Action DialogShowSdUpgrade
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x2000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e003, Disable Back = 0x1
21:45:18 Dialog 0x2000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
21:45:18 Begin Action ShowDialogsHlpr: 0x4000
21:45:18 Skipping DialogShowSdVirtualServer
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e003, nCurrent = 0x4000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x4000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
21:45:18 Begin Action ShowDialogsHlpr: 0x8000
21:45:18 Begin Action : DialogShowSdDiskGroups
21:45:18 ShowDlgDiskGroups returned: 1
21:45:18 Disk Group = SQL Group
21:45:18 End Action : DialogShowSdDiskGroups
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x8000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x8000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
21:45:18 Begin Action ShowDialogsHlpr: 0x10000
21:45:18 Begin Action: DialogShowSdClusterDef
21:45:18 Before !! The Prefowner list is : . g_szSpNeededNodelst is : .
g_nNumnodes :0 g_szOwners :, g_szDiskGroup SQL Group
21:45:18 ShowDlgClusterDef returned: 1
21:45:18 PrefOwners = OMF-DBCLUSTER-A,OMF-DBCLUSTER-B, NumIp = 2
21:45:18 Begin Action : ValidateNodeActions
21:45:18 Begin Action : EnumerateInstancesForVirtualServer
21:45:18 End Action : EnumerateInstancesForVirtualServer
21:45:18 Begin Action : ValidateNodeActions
21:45:18 End Action : ValidateNodeActions
21:45:18 End Action : ValidateNodeActions
21:45:18 End Action DialogShowSdClusterDef
21:45:18 begin ShowDialogsUpdateMask
21:45:18 nFullMask = 0xb03e607, nCurrent = 0x10000, nDirection = 1
21:45:18 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
21:45:18 Dialog 0x10000 returned: 1
21:45:18 End Action ShowDialogsHlpr
21:45:18 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
21:45:18 Begin Action ShowDialogsHlpr: 0x20000
21:45:18 Begin Action : Cluster Security - DlgAcct

Reply to this Message