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
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...B;EN-US;254321
Best Regards,
Uttam Parui
Microsoft Corporation
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
|||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\CommonFi lesDir ...
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\s cm.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\s cm.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.t xt" -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\s cm.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
Showing posts with label apply. Show all posts
Showing posts with label apply. Show all posts
Saturday, February 25, 2012
Problem installing SP2 on active-passive x64 cluster
I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.
Thanks for any help. (I'm at the client today)
Bob Coppedge
me at RLCoppedge dot com
Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
Hey Bob,
Check out this KB Article: http://support.microsoft.com/kb/929151
It references a slightly different error number, but the error messages appear to be the same.
Eric
|||Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.
Thanks again for the lead!
Bob
Glad to help out and glad you got it working!
Eric
|||I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.
Thanks
|||I followed the fix above and it fixed my problem. I running 2k3enterprise with sql2005entx64. I had to add the virtual network name to lmhosts and enable netbios(and lmhosts) on the public nic of each node(two node cluster). Will we ever turn off netbios?
Thanks to the above users for the good links...(Eric)
Forrest
Problem installing SP2 on active-passive x64 cluster
I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.
Thanks for any help. (I'm at the client today)
Bob Coppedge
me at RLCoppedge dot com
Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
Hey Bob,
Check out this KB Article: http://support.microsoft.com/kb/929151
It references a slightly different error number, but the error messages appear to be the same.
Eric
|||Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.
Thanks again for the lead!
Bob
Glad to help out and glad you got it working!
Eric
|||I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.
Thanks
|||
I followed the fix above and it fixed my problem. I running 2k3enterprise with sql2005entx64. I had to add the virtual network name to lmhosts and enable netbios(and lmhosts) on the public nic of each node(two node cluster). Will we ever turn off netbios?
Thanks to the above users for the good links...(Eric)
Forrest
Problem installing SP2 on active-passive x64 cluster
I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.
Thanks for any help. (I'm at the client today)
Bob Coppedge
me at RLCoppedge dot com
Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
Hey Bob,
Check out this KB Article: http://support.microsoft.com/kb/929151
It references a slightly different error number, but the error messages appear to be the same.
Eric
|||Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.
Thanks again for the lead!
Bob
Glad to help out and glad you got it working!
Eric
|||I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.
Thanks
Problem installing SP2
having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' i
s 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
807fe1c" target="_blank">http://groups.google.com/group/micr...
807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>|||cheers john,
I went throo the files (slow friday ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> cf807fe1c" target="_blank">http://groups.google.com/group/micr...r />
cf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' i
s 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
807fe1c" target="_blank">http://groups.google.com/group/micr...
807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo..
)> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>|||cheers john,
I went throo the files (slow friday
) there was a few withoutadministrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> cf807fe1c" target="_blank">http://groups.google.com/group/micr...r />
cf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday
) there was a few without> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>
Problem installing SP2
having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.
Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>
|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>
|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
[url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>
|||cheers john,
I went throo the files (slow friday ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> [url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>
|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>
|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.
Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>
|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>
|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
[url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo..
)> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>
|||cheers john,
I went throo the files (slow friday
) there was a few withoutadministrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> [url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>
|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday
) there was a few without> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>
|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>
Problem installing SP2
having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
:) )
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions but
>> none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running SQL
>> Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
>> 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. :) )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus software
>> being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>|||cheers john,
I went throo the files (slow friday :) ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday :) ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary which
>> was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>|||hi john,
worked great - sorted it all today, :)
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>> cheers john,
>> I went throo the files (slow friday :) ) there was a few without
>> administrator privs, so ive added admin to them
>> ill give it another go, when the server isn't busy
>> cheers
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary
>> which was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the
>> directory owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions
>> on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback'
>> is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value
>> 'DisableRollback' is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>>
>
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
:) )
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions but
>> none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running SQL
>> Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
>> 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. :) )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus software
>> being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>|||cheers john,
I went throo the files (slow friday :) ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday :) ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary which
>> was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>|||hi john,
worked great - sorted it all today, :)
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>> cheers john,
>> I went throo the files (slow friday :) ) there was a few without
>> administrator privs, so ive added admin to them
>> ill give it another go, when the server isn't busy
>> cheers
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary
>> which was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the
>> directory owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions
>> on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback'
>> is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value
>> 'DisableRollback' is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>>
>
Subscribe to:
Posts (Atom)