Problem installing SQL 2005 on a Windows 2003 DC

Hello to all,

we try to install an SQL 2005 server on a Windows 2003 server that is also a Domain controller. In discussions of july last year, Dan Jones said :"Unfortunately in setup you cannot change the default account for all services. So there is absolutely no work around for this problem. This will absolutely be fixed by RTM - "

Can anybody help me in that way. We tried installing with our latest CDs (december 2005)

It's not clear what your problem is. Are you having trouble installing? If so, what is the behavior you're seeing.|||The problem is during installing. Despite the fact that we allocate a domain user account as user for the service accounts, we have a error message "Failure creating local group SQLServer2005SQLBrowserUser$<servername> and the installation does not continue.|||The user that your running setup as doesn't have the correct permissions on the DC to create a new group. To work around this have the group created prior to running setup. In addition, if you don't have permission to add users to a group you can add the domain user to the group prior to running setup. During setup it'll check for the existence of the group and that the user is part of the group. If you set this up prior to running setup you don't need the create group and add to group permissions.|||

I set up different security groups having the name of the desired groups:

SQLServer2005DTSUser$SRV05FIL01

SQLServer2005MSFTEUser$SRV05FIL01$MSSQLSERVER

SQLServer2005MSOLAPUser$SRV05FIL01$MSSQLSERVER

SQLServer2005MSSQLServerADHelperUser$SRV05FIL01

SQLServer2005MSSQLUser$SRV05FIL01$MSSQLSERVER

SQLServer2005NotificationServicesUser$SRV05FIL01

SQLServer2005ReportingServicesWebServiceUser$SRV05FIL01$MSSQLSER

SQLServer2005ReportServerUser$SRV05FIL01$MSSQLSERVER

SQLServer2005SQLAgentUser$SRV05FIL01$MSSQLSERVER

SQLServer2005SQLBrowserUser$SRV05FIL01

Those groups have as members the user that is running the setup, domain-user and domain-admin. The problem is still the same: error message: "Failure creating local group SQLServer2005SQLAgentUser$SRV05FIL01$MSSQLSERVER".

As we have a DC, there is no way to declare local groups.

I can send you the logfile if desired.

|||Go ahead and log a bug using: http://lab.msdn.microsoft.com/ProductFeedback/|||

Create those groups on you 1st domain controller , force a replication of AD and you have all these groups on your new server . the installation of sql will now find these groups and set the security on it..

Gtz

Problem installing sql 2005 express cannot start service etc.... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=318735&SiteID=1&mode=1

Problem installing sql 2005 express cannot start service etc.... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=318735&SiteID=1&mode=1

Problem installing sql 2005 express cannot start service .... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=318735&SiteID=1&mode=1

Problem Installing SQL 2000 Sp4

While upgrading Sql 2000 Sp3 thge installer is starting to install the service pack. But after running the scripts he gives a very strange error.

error running: 80sp4-tools.sql (1).

after searching and living on google for 3 days for information about this error, I'am no

really desperate.

I hope someone help me or tell me more about this error.

thanks so far

See the following thread...it may help you...

http://www.ureader.com/message/647952.aspx

|||

Thanks MohammedU,

That problem looks exactly as my problem but, the sp4 is starting to install till script 80sp4-tools.sql. and then the installer stops with the same as in the given thread.

the only error that was given in the log file was "(1)"

thanks so far.

Problem installing SQL 2000 on SBS2003

Hi,
I am getting an error right after it asks if the server is local or remote.
It says that a previous program installation created pending file operations
on the installation machine. And that i must restart the computer. I've
restarted...doesn't make a difference. The server has MSDE for sbs
installed. Not sure what to do.
Thanks,
Andrew OuellettePlease try the following:
1. Run Registry Editor
2. Go to HKEY_LOCAL_MACHINE folder
3. Go to SYSTEM folder
4. Go to CurrentControlSet folder
5. Go to Control folder
6. Go to Session Manager folder
7. Double-click on the PendingFileRenameOperations key
and remove everything from the Value Data section
This ought to do it, I hope!
Thanks,
Dee
>--Original Message--
>Hi,
>I am getting an error right after it asks if the server
is local or remote.
>It says that a previous program installation created
pending file operations
>on the installation machine. And that i must restart the
computer. I've
>restarted...doesn't make a difference. The server has
MSDE for sbs
>installed. Not sure what to do.
>Thanks,
>Andrew Ouellette
>.
>

problem installing sp4 on msde 2000 release A

Hello,
When I try to run the setup with the parameters I need (I have a default
instance installed already) to upgrade MSDE 2000 the setup program runs with
a blue screen on background and a modal window appears showing me the
parameters (like /i /p /v etc.). It seems to me that the setup is somehow
messed (I wonder if has something to do with the Windows Installer). Can
anyone help?
Thanks!
hi Leonardo,
Leonardo wrote:
> Hello,
> When I try to run the setup with the parameters I need (I have a
> default instance installed already) to upgrade MSDE 2000 the setup
> program runs with a blue screen on background and a modal window
> appears showing me the parameters (like /i /p /v etc.). It seems to
> me that the setup is somehow messed (I wonder if has something to do
> with the Windows Installer). Can anyone help?
have you tried re-downloading the sp4 package? perhaps it' corrupted..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Problem installing SP4

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

Problem installing SP3a

I have kind of a messed up server I think. It had two instances of SQL
Server installed and I removed one.
Now, I'm getting an error trying to schedule run a scheduled DTS job. I
looked it up in the knowledge base and the best answers were to re-install
the service pack. So...
Reinstalling the service pack failes because it looks like the service pack
wants to authenticate itself to the SQL Server but can't. My guess is it
can't find the right instance to use to authenticate.
Does anyone know where I can set this? It sees the instance and brings it
up during the installation process, but both SQL Server authentication and
Windows Authentication both fail. I get the error message "Setup was unable
to validate the logged user. Press Retry to enter another option, or Cancel
to exit setup."
I tried the resolutions in Q814844 but they were either already set or
didn't make a difference. I'm guessing it might have something to do with
the second instance throwing off the installation so it doesn't know where
to authenticate itself.
Any ideas?
Thanks,
GaryDid you use "sa" and the corresponding password for the same ?
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Gary" <tuffboystl@.hotmail.com> wrote in message
news:eYlt7KjdDHA.1880@.TK2MSFTNGP10.phx.gbl...
> I have kind of a messed up server I think. It had two instances of SQL
> Server installed and I removed one.
> Now, I'm getting an error trying to schedule run a scheduled DTS job. I
> looked it up in the knowledge base and the best answers were to re-install
> the service pack. So...
> Reinstalling the service pack failes because it looks like the service
pack
> wants to authenticate itself to the SQL Server but can't. My guess is it
> can't find the right instance to use to authenticate.
> Does anyone know where I can set this? It sees the instance and brings it
> up during the installation process, but both SQL Server authentication and
> Windows Authentication both fail. I get the error message "Setup was
unable
> to validate the logged user. Press Retry to enter another option, or
Cancel
> to exit setup."
> I tried the resolutions in Q814844 but they were either already set or
> didn't make a difference. I'm guessing it might have something to do with
> the second instance throwing off the installation so it doesn't know where
> to authenticate itself.
> Any ideas?
> Thanks,
> Gary
>|||yes.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:O%23YUONodDHA.1620@.TK2MSFTNGP12.phx.gbl...
> Did you use "sa" and the corresponding password for the same ?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Gary" <tuffboystl@.hotmail.com> wrote in message
> news:eYlt7KjdDHA.1880@.TK2MSFTNGP10.phx.gbl...
> > I have kind of a messed up server I think. It had two instances of SQL
> > Server installed and I removed one.
> >
> > Now, I'm getting an error trying to schedule run a scheduled DTS job. I
> > looked it up in the knowledge base and the best answers were to
re-install
> > the service pack. So...
> >
> > Reinstalling the service pack failes because it looks like the service
> pack
> > wants to authenticate itself to the SQL Server but can't. My guess is
it
> > can't find the right instance to use to authenticate.
> >
> > Does anyone know where I can set this? It sees the instance and brings
it
> > up during the installation process, but both SQL Server authentication
and
> > Windows Authentication both fail. I get the error message "Setup was
> unable
> > to validate the logged user. Press Retry to enter another option, or
> Cancel
> > to exit setup."
> >
> > I tried the resolutions in Q814844 but they were either already set or
> > didn't make a difference. I'm guessing it might have something to do
with
> > the second instance throwing off the installation so it doesn't know
where
> > to authenticate itself.
> >
> > Any ideas?
> >
> > Thanks,
> > Gary
> >
> >
>

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

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

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