SQL Server 2005 Express Edition with Advanced Services Service Pack 2 - Error 65B

Hi -

Who else had received this error during Windows update I'm running Vista ultimate. There are a couple of posts on google, but no solutions yet.

To my knowledge, no one on this forum is clarvoyant, so you'll need to post the details of the error you're getting in order to get any help. There is a known issue if you have ACT! 2007 installed that it cannot be patched correctly because of the way the ACT! product installs SQL Express. There should be an update from ACT! in the next several weeks that will correctly apply the update. If you don't have ACT! installed I'm interested in understanding the problem you're seeing.

Mike

It would help to have a look at the install log file, they are located in the setup log folder at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. If this is the update comming from Microsoft Update, you'll want to look in the Hotfix folder and check out summary.txt.

Mike

Mike -

Here's the Hotfix log. Hope this helps. Thanks!

Time: 04/25/2007 11:16:07.666
KB Number: KB921896
Machine: FLATBOY
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services Adv (MIKESQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS_ADVANCED
Express Database Services Adv (SQLEXPRESS) ENU SP1 2005.090.2047.00 x86 EXPRESS_ADVANCED
Express Database Services Adv (SQLEXPRESSRS) ENU SP2 x86 EXPRESS_ADVANCED
Express Database Services Adv (SQLEXPRESSRS) ENU SP2 2005.090.3042.00 x86 EXPRESS_ADVANCED

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services Adv (MIKESQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Express Database Services Adv (SQLEXPRESS)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_ADV.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 1627
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product : Express Database Services Adv (SQLEXPRESSRS)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR_ADV.EXE
SQL Express Features : RS_Server,RS_SharedTools,RS_Web_Interface
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Express Database Services Adv (SQLEXPRESSRS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1627

Hi Folks,

I've been investigating this with our setup team and we need more information to help us investigate. Mostly we need the complete set of log files from the directory listed in the Summary.txt file that you've posted. Rather than try to manage this via e-mail, or through posting complete logs in the forum, I'd like to use Microsoft Connect:

1. Navigate to https://connect.microsoft.com/SQLServer.
2. Register if you haven't already.
3. Submit feedback for this issue and attach the logs for the failure.

This will create a trackable item in our system and allow me to drive this through the investigation process. Feel free to let me know when you've done this so I can go and find your feedback item.

Mike

Mike - I've submitted the feedback with a zip of the log files. Feedback ID 274577. Let me know if you need more info.

For folks who are experiencing this problem on Windows Vista, the problem is likely related to some issues with Reporting Services. (At lease one set of logs submitted clearly showed this.) There is a KB article explaining how to handle the Vista upgrade of RS at http://support.microsoft.com/default.aspx/kb/934163/en-us. Take a look at that and tell me if that resolve the problems you're seeing.

Mike

jona.than -

Check out this link:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=274577