Extracting Sql: sp1

Showing posts with label sp1. Show all posts

Tuesday, March 27, 2012

Failed to install: Cumulative hotfix package (build 2153) for SQL Server 2005 (KB918222)

Hi experts!

I try to update SQL Server 2005 SP1 with the Cumulative hotfix package (build 2153). I need to do this, because I get an error this hotfix is said to fix... and of course - the update completely crashes (sending an error report to microsoft).

Here is what the log looks like:

Failed ACL:
SetSecurityFileDescriptor is failed at the error code 5; Converted SDDL: '(A;OICI;FA;;;S-1-5-21-1276437202-3579633377-1796755180-1012)'
Error Code: 0x80077342 (29506)
Windows Error Text: Source File Name: sqlca\sqlsddlca.cpp
Compiler Timestamp: Tue Apr 11 11:45:24 2006
Function Name: ExceptionInSDDL
Source Line Number: 65

- Context --

Setting status of unmanaged components and removing unmanaged resources

MSI (s) (50!B4) [23:18:29:854]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:854]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!B4) [23:18:29:854]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:854]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:854]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!B4) [23:18:29:854]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:854]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (50!B4) [23:18:29:854]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:854]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!B4) [23:18:29:870]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:870]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:870]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!B4) [23:18:29:870]: Transforming table Error.

MSI (s) (50!B4) [23:18:29:870]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!B4) [23:18:29:870]: Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user SQL. 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 SQL. 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.
<Failure Type='Fatal' Error='29506'>
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (50:34) [23:18:29:886]: User policy value 'DisableRollback' is 0
MSI (s) (50:34) [23:18:29:886]: Machine policy value 'DisableRollback' is 0
Action ended 23:18:29: InstallFinalize. Return value 3.
MSI (s) (50:34) [23:18:29:964]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=910146116,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (50:34) [23:18:29:964]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (50:34) [23:18:29:964]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (50:34) [23:18:29:964]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (50:34) [23:18:29:964]: Executing op: RegisterBackupFile(File=C:\Config.Msi\643b07e2.rbf)
MSI (s) (50:34) [23:18:29:964]: Executing op: RegisterBackupFile(File=C:\Config.Msi\643b07e3.rbf)
MSI (s) (50:34) [23:18:29:979]: Executing op: RegisterBackupFile(File=C:\Config.Msi\643b07e4.rbf)
MSI (s) (50:34) [23:18:29:979]: Executing op: RegisterBackupFile(File=C:\Config.Msi\643b07e5.rbf)
MSI (s) (50:34) [23:18:29:979]: Executing op: RegisterBackupFile(File=C:\Config.Msi\643b07e6.rbf)
MSI (s) (50:34) [23:18:29:979]: Executing op: ActionStart(Name=Do_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting File Security,Template=File: [1])
MSI (s) (50:34) [23:18:29:979]: Executing op: ProductInfo(ProductKey={130A3BE1-85CC-4135-8EA7-5A724EE6CE2C},ProductName=Microsoft SQL Server 2005,PackageName=SqlRun_SQL.msi,Language=1033,Version=151062527,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={3185FC73-41E0-43F4-97DF-2254C4D7C667},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (50:34) [23:18:29:979]: Executing op: ActionStart(Name=Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting User Security,Template=Account: [1])
MSI (s) (50:34) [23:18:29:979]: Executing op: ActionStart(Name=Do_sqlGroupMember.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing Local Groups,)
MSI (s) (50:34) [23:18:29:979]: Executing op: ActionStart(Name=Rollback_sqlGroupMember.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing Local Groups,)
MSI (s) (50:34) [23:18:29:979]: Executing op: CustomActionRollback(Action=Rollback_sqlGroupMember.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlGroupMember,CustomActionData=1 0 0 Installing Local Groups 50000 SQLServer2005MSFTEUser$KMAUSQL01SRV$MSSQLSERVER NT AUTHORITY\LocalService )
MSI (s) (50:68) [23:18:29:995]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSICD9.tmp, Entrypoint: Rollback_sqlGroupMember
<Func Name='LaunchFunction'>

I would really be thankful for any hint regarding what to do to solve this problem.... As said - I have an error occuring, this hotfix is said to fix - to be exact, it's the one stating "not to be able to build the execution plan under some circumstances when using a SQL query inside a stored procedure"

Help greatly appreciated!!

Greetings, Wolfgang

Make sure the acct used to startup sqlserver service has read/write access to the folder listed. Also, be sure you login as admin to run setup.

|||

Thanks for your reply oj!

Actually I was logged in as member of the 'Administrators' group... That's what bugged me so much... But as I followed your hint and tried to modify the permissions of the folder manually I immediately got a Windows-Authentication Modal Popup - telling me that I have to authenticate to the domain...

So the problem was that I was local administrator but the hotfix-installation in fact needed mit to be also domain-administrator (don't really understand why though).

I just contacted the Domain-Admin and made him install the hotfix ;-) It worked... Thanks for the hint!

Regards,
Wolfgang

Friday, March 23, 2012

Failed to deploy reports after installing Reporting Services SP1

Hi,
Before installing Reporting Services SP1, I can deploy and view reports.
Everything works fine. However, after I installed Reporting Services SP1, I
can not deploy all my reports to Report Servers. On the other hand, I can
preview the reports through Visual Studio .NET and it looks very normal.
Can anybody give me some suggestions?
Thanks a lot.
DavidHi,
The problem was fixed after re-installing enterprise version Reporting
Services and SP1.
"David" wrote:
> Hi,
> Before installing Reporting Services SP1, I can deploy and view reports.
> Everything works fine. However, after I installed Reporting Services SP1, I
> can not deploy all my reports to Report Servers. On the other hand, I can
> preview the reports through Visual Studio .NET and it looks very normal.
> Can anybody give me some suggestions?
> Thanks a lot.
> David

Monday, March 19, 2012

Failed Node Need to rebuild

I am having an issue with the primary node of our SQL 2005 x64 Cluster
(Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
below error when the service tries to start.
So obviously I messed up something during the upgrade. So decided to write
this node off and try and reinstall SQL. Unfortunately it will not
uninstall because it can not see the quorum drive even though it really is
there. Obviously I can not move the group because the service is failed.
How can I for uninstall SQL to try and rebuild the node? Has anyone seen
this issue before? I would rather not rebuild the OS if possible. It is
only SQL that is failing the rest of the box it working great.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 11/22/2006
Time: 8:33:48 AM
User: N/A
Computer: SQL001A
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Hi Tim,
I ran into a similar issue when working on SQL 20056 clusters in my lab. I
did find a link that was very useful when trying to uninstall a node manually.
Take a look at this one and let me know if it helps;
http://msdn2.microsoft.com/en-US/library/ms180973.aspx
Regards,
Sporter
"Tim Murray" wrote:

> I am having an issue with the primary node of our SQL 2005 x64 Cluster
> (Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
> below error when the service tries to start.
> So obviously I messed up something during the upgrade. So decided to write
> this node off and try and reinstall SQL. Unfortunately it will not
> uninstall because it can not see the quorum drive even though it really is
> there. Obviously I can not move the group because the service is failed.
> How can I for uninstall SQL to try and rebuild the node? Has anyone seen
> this issue before? I would rather not rebuild the OS if possible. It is
> only SQL that is failing the rest of the box it working great.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7024
> Date: 11/22/2006
> Time: 8:33:48 AM
> User: N/A
> Computer: SQL001A
> Description:
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
>
>

Failed Install of SQL Server 2005 SP1 CTP

Hello,

We are attempting to install the CTP for SQL Server 2005 SP1 and receive the following error message in the log:

The following exception occurred: Unable to install Windows Installer MSP file Date: 03/24/2006 14:19:40.562 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 856This is

then followed by this failure with the Database Services:

Product: Database Services Database Services (RTM 1399 ENU)- Failure Details: Unable to install Windows Installer MSP file

I also found the following entry in the SQL9_Hotfix_KB913090_sqlrun_sqlmsp.log file:

SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

Thanks in advance for any assistance, --John

This is puzzling. We found and fixed one bug generating the first error before releasing the CTP. Could you describe your installation and post a link to the setup log files? I think someone will need to pore over them to understand the problem.|||

Could you go ahead and log a bug using: http://lab.msdn.microsoft.com/ProductFeedback ?

|||I'm getting the same error with the final release.|||

Kevin, can you attach your msp log as well? The file is SQL9_Hotfix_KB913090_sqlrun_sql.msp.log. Are you applying SP1 to an RTM install or did you apply a previous SP1 build along the way?

Thanks,
Samuel Lester (MSFT)

|||Samuel, I just attempted to run the new SP1 and got the same problem as the original post (regarding "dm_exec_query_resource_semaphore"). I also found in the log file the same problem with the object named dm_exec_query_memory_grants.|||

Glenn, can you supply me with the log file I referenced above? This may help us determine why the object seems to be having permission issues.

Thanks,
Samuel Lester (MSFT)

|||I'm getting the same error, here's the tail of my log file (the whole thing is about 9MB, cant really post that :/)

Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
Property(S): UpgradeInstruction = Connect to SQL instance SRVHAM14 as sysadmin
Launch SQL statement USE master
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\repl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (20:A4) [13:56:22:544]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 1 for SQL Server Database Services 2005 (64-bit) ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 1729
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:560]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.

MSI (s) (20:A4) [13:56:22:560]: Attempting to delete file C:\WINDOWS\Installer\4aaf165.msp
MSI (s) (20:A4) [13:56:22:575]: Cleaning up uninstalled install packages, if any exist
MSI (s) (20:A4) [13:56:22:575]: Post-install cleanup: removing installer file 'C:\WINDOWS\Installer\4aaf165.msp'
MSI (s) (20:A4) [13:56:22:575]: MainEngineThread is returning 1603
MSI (s) (20:98) [13:56:22:575]: Destroying RemoteAPI object.
MSI (s) (20:0C) [13:56:22:575]: Custom Action Manager thread ending.
=== Logging stopped: 21/04/2006 13:56:22 ===
MSI (c) (58:60) [13:56:22:606]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (58:60) [13:56:22:606]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21/04/2006 13:56:22 ===

|||Little more, first time the error shows up in the logs:

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.

<Started SQL statement: Fri Apr 21 13:56:07 2006> USE master
SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.

<Finished SQL statement: Fri Apr 21 13:56:07 2006>
<Started SQL script: Fri Apr 21 13:56:07 2006> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql in Unicode mode
SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.
sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission.

|||Ok, some more digging into the upgrade scripts reveals this as the offending query (sysdbupg.sql):

-- Grant SELECT on Shiloh views to PUBLIC (only if they were not explicitely denied)
--
use master
go

set nocount on
set implicit_transactions off
set ansi_nulls on -- default for osql (consistent for suites)
set quoted_identifier on -- Force all ye devs to do this correctly!
go

-- temporary grant select to QE dmv
GRANT SELECT on sys.dm_exec_query_resource_semaphores TO PUBLIC
GRANT SELECT on sys.dm_exec_query_memory_grants TO PUBLIC

The error tells us that either these dont exist, or we dont have permission to them... And I believe they don't exist (certainly not post failed upgrade anyway). If there's another part of the upgrade that's supposed to create those table valued functions, it isn't doing so.
|||

Hey,

I also am getting this error on attempting to install Microsoft SQL Server 2005 Service Pack 1. :(

That is "Unable to install Windows Installer MSP file" .

I do not see any "SQL9_Hotfix_KB913090_sqlrun_sql.msp.log" file.

On my system it is "Redist9_Hotfix_KB913090_SqlSupport.msp.log". At least according to the event log:

"Product: Microsoft SQL Server Setup Support Files (English) - Update '{EE92F683-5F5C-4970-BB0B-9AC591B60268}' could not be installed. Error code 1642. Additional information is available in the log file C:\WINNT\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log."

So here is the log file:

=== Verbose logging started: 4/21/2006 12:23:36 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\WINNT\system32\msiexec.exe ===
MSI (c) (A4:58) [12:23:36:625]: Resetting cached policy values
MSI (c) (A4:58) [12:23:36:625]: Machine policy value 'Debug' is 0
MSI (c) (A4:58) [12:23:36:625]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (A4:58) [12:23:36:625]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (A4:58) [12:23:36:625]: Grabbed execution mutex.
MSI (c) (A4:58) [12:23:36:640]: Cloaking enabled.
MSI (c) (A4:58) [12:23:36:640]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (A4:58) [12:23:36:640]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (4C:6C) [12:23:36:640]: Grabbed execution mutex.
MSI (s) (4C:EC) [12:23:36:640]: Resetting cached policy values
MSI (s) (4C:EC) [12:23:36:640]: Machine policy value 'Debug' is 0
MSI (s) (4C:EC) [12:23:36:640]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (4C:EC) [12:23:36:640]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (4C:EC) [12:23:36:656]: End dialog not enabled
MSI (s) (4C:EC) [12:23:36:656]: Original package ==> C:\WINNT\Installer\1f5f617.msi
MSI (s) (4C:EC) [12:23:36:656]: Package we're running from ==> C:\WINNT\Installer\1f5f617.msi
MSI (s) (4C:EC) [12:23:36:656]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (4C:EC) [12:23:36:656]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (4C:EC) [12:23:36:656]: MSCOREE already loaded, using loaded copy
MSI (s) (4C:EC) [12:23:36:671]: File will have security applied from OpCode.
MSI (s) (4C:EC) [12:23:36:718]: Original patch ==> d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (4C:EC) [12:23:36:718]: Patch we're running from ==> C:\WINNT\Installer\1f5f686.msp
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'd:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp' against software restriction policy
MSI (s) (4C:EC) [12:23:36:718]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp is not digitally signed
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (4C:EC) [12:23:36:718]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.2047.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033
MSI (s) (4C:EC) [12:23:36:718]: PATCH SEQUENCER WARNING: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp patch will not be sequenced because it does not contain any transform that may apply to product!
MSI (s) (4C:EC) [12:23:36:718]: SequencePatches returns success.
MSI (s) (4C:EC) [12:23:36:718]: Final Patch Application Order:
MSI (s) (4C:EC) [12:23:36:718]: Other Patches:
MSI (s) (4C:EC) [12:23:36:718]: Unknown\Absent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} - d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (4C:EC) [12:23:36:734]: Product: Microsoft SQL Server Setup Support Files (English) - Update '{EE92F683-5F5C-4970-BB0B-9AC591B60268}' could not be installed. Error code 1642. Additional information is available in the log file C:\WINNT\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log.

MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 1708
MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 2729
MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 2729
MSI (s) (4C:EC) [12:23:36:734]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

MSI (s) (4C:EC) [12:23:36:734]: Attempting to delete file C:\WINNT\Installer\1f5f686.msp
MSI (s) (4C:EC) [12:23:36:750]: MainEngineThread is returning 1642
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer an
d that you have the correct upgrade patch.
C:\WINNT\Installer\1f5f617.msi
MSI (c) (A4:58) [12:23:36:750]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (A4:58) [12:23:36:750]: MainEngineThread is returning 1642
=== Verbose logging stopped: 4/21/2006 12:23:36 ===

Yes I am sure I am installing the right patch. Just downloaded from here:

http://www.microsoft.com/downloads/details.aspx?familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en

At the start of setup it even shows that it can update all the installed products to SP1.

So far I have tried everything. I even completely uninstalled Visual Studio 2005 professional, along with .net 2.0, etc. Everything on the uninstall page:

http://msdn.microsoft.com/vstudio/express/support/uninstall/

So I started all over again, and once again SP1 fails to install with the same error as everyone else. :(

Any help would be great.

Thanks a lot,

Will

|||

After you get the 'dm_exec_query_resource_semaphores' error and the installer cancels out, can you try to apply SP1 a second time? Does that attempt also fail with the same message?

Thanks,
Samuel Lester (MSFT)

|||

Samuel,

I too am getting the MSP error. I did sucessfully install SP1 to SQL 2005 Express prior to my attempt to update SQL 2005 Developer Edition. I have uninstalled SQL 2005 Express and tried to apply SP1 to SQL 2005 Server DE, but get the same error.

I have logs - where would you like me to mail them?

bill burrows

|||

Samuel, the site http://lab.msdn.microsoft.com/ProductFeedback would not allow me to post this issue. So, I have included the following lines from the log file SQLSetup0012_<mycomputername>_SQL.log:

SQL_ERROR (-1) in OdbcStatement::execute_batch

sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.

sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission.

Error Code: 0x80073b2f (15151)

Windows Error Text: Source File Name: lib\odbc_statement.h

Compiler Timestamp: Wed Oct 26 16:37:41 2005

Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.2

Source Line Number: 91

Error Code: 15151

MSI (s) (B4!8C) [16:45:40:458]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.

I hope this helps!

Glenn

|||I have attempted to run SP1 (for SQL Express) 3 times; each time with the same error. Also, I initially installed SP1 for SQL Server 2005 with no problems.

Tuesday, March 27, 2012

Failed to install: Cumulative hotfix package (build 2153) for SQL Server 2005 (KB918222)

Friday, March 23, 2012

Failed to deploy reports after installing Reporting Services SP1

Monday, March 19, 2012

Failed Node Need to rebuild

Failed Install of SQL Server 2005 SP1 CTP

Extracting Sql

Blog Archive

About Me