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

Answer this question

Failed Install of SQL Server 2005 SP1 CTP

Rasheed1979
Could you go ahead and log a bug using: http://lab.msdn.microsoft.com/ProductFeedback
Roshec
I'm getting the same error, here's the tail of my log file (the whole thing is about 9MB, cant really post that :/)
_howard
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
RussMan
Little more, first time the error shows up in the logs:
Ariff

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)
simon denyer
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.
platysternon
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.
Ronnell

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)
techbd

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)
davef8
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.
dhum11
Ok, some more digging into the upgrade scripts reveals this as the offending query (sysdbupg.sql):
liquidVapour

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:

<from line 28321>

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

<from line 28440>

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.

<Failure Type='Fatal' Error='15151'>

<EndFunc Name='LaunchFunction' Return='15151' GetLastError='203'>

I hope this helps!

Glenn
Gethyn
I'm getting the same error with the final release.
RobertaK

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
Failed Install of SQL Server 2005 SP1 CTP

Answer this question