Guest freerider Posted July 9, 2008 Posted July 9, 2008 "cmbarbi" wrote: > I had same error code KB948109 Update Error Code 733F. Turned off firewall > and repeated install. All worked fine. > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions? I turned off both the firewall and anti-virus software and it didn't work for me.
Guest AMP Posted July 9, 2008 Posted July 9, 2008 I fixed this just by getting all services running in SQL Server Configuration Manager before applying the update (I even didn't need to download the package, it worked fine just with the Automatic Update) "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Leifons Posted July 9, 2008 Posted July 9, 2008 Haven't solved it completely but I did manage to update all SQL Server instances except SQL Server Express. The downloadable patch (http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en) lets you select which instances to upgrade and it’s more verbose during installation. See the log file afterwards. SQL Server Express had the status "upgradeable" instead of "upgraded" as all the others did. I also had to stop the SQL Server Express service before being able to continue.
Guest Joshua Posted July 9, 2008 Posted July 9, 2008 I finally made it!!! Stopped all Anti-Virus and Firewall services (Sophos in my case) and then -that´s the way the cookie crumbles- set the "Hilfsdienst von SQL Server für Active Directory" from disabled to manual and started it. As this a german windows copy, the english name for this service should be something like "SQL Server Helper Service for Active Directory". After starting this particular service I downloaded KB948109 from MS and ran the Setup interactively. This way round the patch could be successfully applied. Hope anyone can find this helpful. -) Cheers, Joshua "jluptak" wrote: > This update needs to be installed interactively. It failed for me when I > used the auto-update. So I downloaded it and ran it separately. I also, > beforehand, made sure all instance of SQL were started (mine is a dev't > machine with several instances). Also, in the course of the install (and > this is what breaks it in auto mode) you are asked to kill some processes -- > like Microsoft Integration services and the SQLExpress process. > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Tom Posted July 9, 2008 Posted July 9, 2008 Going to call to MS. I will post the results when I get them. "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Kloser Posted July 9, 2008 Posted July 9, 2008 I also have had this problem, and I tried the above fix - which did not work for me. In my case, the express edition is all I have installed – so unchecking that option made no difference. I think there is a problem with this fix as applied to the express edition. "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Cj00098 Posted July 9, 2008 Posted July 9, 2008 Too bad MS (Microsoft) did not plan for this fix to be such a problem,,, so much for auto updates,,, bad planning,,, and poor help on fixes,,, once again,,,, bad pretesting,,,,, "Joshua" wrote: > I finally made it!!! > > Stopped all Anti-Virus and Firewall services (Sophos in my case) and then > -that´s the way the cookie crumbles- set the "Hilfsdienst von SQL Server für > Active Directory" from disabled to manual and started it. > > As this a german windows copy, the english name for this service should be > something like "SQL Server Helper Service for Active Directory". > > After starting this particular service I downloaded KB948109 from MS and ran > the Setup interactively. > > This way round the patch could be successfully applied. > > Hope anyone can find this helpful. -) > > Cheers, > Joshua > > "jluptak" wrote: > > > This update needs to be installed interactively. It failed for me when I > > used the auto-update. So I downloaded it and ran it separately. I also, > > beforehand, made sure all instance of SQL were started (mine is a dev't > > machine with several instances). Also, in the course of the install (and > > this is what breaks it in auto mode) you are asked to kill some processes -- > > like Microsoft Integration services and the SQLExpress process. > > > > "Mike Moore" wrote: > > > > > All updates installed normally except the one for Sql Server 05 above. > > > Failed info provided error code 0x733F. Can't find any help references to > > > that error code. Any suggestions?
Guest camelx Posted July 10, 2008 Posted July 10, 2008 Guys, The problem is not with ticking checkboxes or with the patch itself. The problem is that not all the SQL server instances can actually start up because the master database and log files are compressed (by Disk cleanup). You usually only use one instance in a SQLExpress installation but there are more than one, which only gets accessed with a patch or service pack update, hence the reason why it fails. "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Bucket Posted July 10, 2008 Posted July 10, 2008 Update worked fine on my desktop (X86, XP SP3, 2GB ram). Fails on my laptop (X86, XP SP3, 4GB ram, almost identical software to my desktop). Have tried all suggestions I can find from many sites... * Tried to get it to work using automatic updates - always failed. * Reboot PC - still failed. * Reinstalled automatic update software and try again - still failed. * Checked SQL server databases not compressed. * Checked SQL server instances running (tried all combinations of running and stopped). * Downloaded the X86 patch and installed manually - still failed. * Tried disabling parts of the patch (e.g. switch of SQL Express) - still failed. * Finally gave up and disabled the update! Am looking again for information on the net to see if a solution has been posted. Bucket "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Bucket Posted July 10, 2008 Posted July 10, 2008 Update worked fine on my desktop (X86, XP SP3, 2GB ram). Fails on my laptop (X86, XP SP3, 4GB ram, almost identical software to my desktop). Have tried all suggestions I can find from many sites... * Tried to get it to work using automatic updates - always failed. * Reboot PC - still failed. * Reinstalled automatic update software and try again - still failed. * Checked SQL server databases not compressed. * Checked SQL server instances running (tried all combinations of running and stopped). * Downloaded the X86 patch and installed manually - still failed. * Tried disabling parts of the patch (e.g. switch of SQL Express) - still failed. * Tried disabling firewall and anti-virus - still failed. * Finally gave up and disabled the update - Many thanks microsoft for wasting my morning! Am looking again for information on the net to see if a solution has been posted. Bucket
Guest HKL Posted July 10, 2008 Posted July 10, 2008 Same problem here Tried all the above suggestions incl som others found in other forums Im runnning Vista SP1 and SQL Express i have two SQL instances one for CRM and one for MAPS....MAPS patch ok but CRM keeps getting the update error. Strange thing is the update removes the "network service" from the SQLSErver2005MSSQLUser... group making the service unable to start. i manually has to add to the group after to make the sql service start. Would be nice with a solution soon "Bucket" wrote: > Update worked fine on my desktop (X86, XP SP3, 2GB ram). > > Fails on my laptop (X86, XP SP3, 4GB ram, almost identical software to my > desktop). Have tried all suggestions I can find from many sites... > * Tried to get it to work using automatic updates - always failed. > * Reboot PC - still failed. > * Reinstalled automatic update software and try again - still failed. > * Checked SQL server databases not compressed. > * Checked SQL server instances running (tried all combinations of running > and stopped). > * Downloaded the X86 patch and installed manually - still failed. > * Tried disabling parts of the patch (e.g. switch of SQL Express) - still > failed. > * Tried disabling firewall and anti-virus - still failed. > * Finally gave up and disabled the update - Many thanks microsoft for > wasting my morning! > > Am looking again for information on the net to see if a solution has been > posted. > > Bucket >
Guest Bucket Posted July 10, 2008 Posted July 10, 2008 I found the solution on my laptop: I use a number of substituted drives: T:, U:, V:, W:, X:, Y: and Z: (all created using the SUBST command in a command file run at login). The patch works perfectly if I remove all of these using several SUBST <drive-letter>: /d commands from a command window. What I do not understand is that the patch worked on my desktop which also has substituted drives: T:, X:, Y: and Z: (U:, V: and W: in this case are networked drives). Bucket
Guest Luc Posted July 10, 2008 Posted July 10, 2008 On Wed, 9 Jul 2008 11:10:02 -0700, jluptak <jluptak@discussions.microsoft.com> wrote: > This update needs to be installed interactively. It failed for me when I > used the auto-update. So I downloaded it and ran it separately. I also, > beforehand, made sure all instance of SQL were started (mine is a dev't > machine with several instances). Also, in the course of the install (and > this is what breaks it in auto mode) you are asked to kill some processes -- > like Microsoft Integration services and the SQLExpress process. The opposite here: it doesn't ask to stop anything, but each time I try to install the update on my development machine, I get a popup from Vista saying the SQL server service crashed (or ermmm, "stopped working"). I have only one instance installed, SQL 2005 developer edition (from MSDN), so there's no Express to uncheck in the interactive installer either. Next thing I'm going to try (I can spare some time now) is detach my user databases and make sure I have backup copies of the mdf and ldf, uninstall, reinstall, get all updatees, and then re-attach my databases. Regardless of whether it works or not, I'll post the result somewhere in this thread.
Guest dp Posted July 10, 2008 Posted July 10, 2008 Well, that does not explain why sql server won't get patched. I don't have a master database on my pc. I only have the client tools. The patch indicates it could not perform the update on one of my pc's but worked fine on another pc. "camelx" wrote: > The reason for the error is that the patch tries to update both instances if > MS SQL: SQLSERVER and SQLSERVER\EXPRESS. Usually one of these won't start > becasue the master database files in the Data directory is compressed. SQL > can't start the service of an instance if the master database file and log > file are compressed. Same reason why the patch does not apply. Just > uncompress these files, start the service for both instances and apply the > patch. (files get compressed when disk cleanup is run!). > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Cj00098 Posted July 10, 2008 Posted July 10, 2008 yes,,, going to the web address is a help,,,,, thank you,,,, Cj "Tornalca" wrote: > Hi All > > I don't work for MS but this is how you fix the problem. Download the update > directly from here : > > http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en > > When installing untick the SQL Express Instance(This is what makes it fail), > I don't use it so do not care if this is updated. Install all the other > updates to SQL intances. > > Carry on with your lives! > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Cj00098 Posted July 10, 2008 Posted July 10, 2008 and yes ,, when it was unticked ,,, it was a successful update,,, so,, thank you,,,,,, for your help,,,, Cj 00098 "Tornalca" wrote: > Hi All > > I don't work for MS but this is how you fix the problem. Download the update > directly from here : > > http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en > > When installing untick the SQL Express Instance(This is what makes it fail), > I don't use it so do not care if this is updated. Install all the other > updates to SQL intances. > > Carry on with your lives! > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Cj00098 Posted July 10, 2008 Posted July 10, 2008 "Tornalca" gets a GOLD STAR,,,,, From Cj00098,, thank you,,,, > Hi All > > I don't work for MS but this is how you fix the problem. Download the update > directly from here : > > http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en > > When installing untick the SQL Express Instance(This is what makes it fail), > I don't use it so do not care if this is updated. Install all the other > updates to SQL intances. > > Carry on with your lives! > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Terry Posted July 10, 2008 Posted July 10, 2008 I have tried downloading the update from http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en and running it. I have no SQL express running on my windows SBS 2003 sp2 so that didn't make any difference. When I look at the log file I get Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3054 Product Version (Final) : Status : Failure Log File : XXXXXX\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB948109_sqlrun_sql.msp.log Error Number : 29506 Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file XXXXXX\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. Which indicates that the administrator is denied access to the folder permissions? I have tried this with SQL instances started and stopped Does anyone have any ideas? "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Paul Posted July 10, 2008 Posted July 10, 2008 Unchecking SQL express worked for me but how do I update SQL express? "Mike Moore" wrote: > All updates installed normally except the one for Sql Server 05 above. > Failed info provided error code 0x733F. Can't find any help references to > that error code. Any suggestions?
Guest Luc Posted July 10, 2008 Posted July 10, 2008 On Thu, 10 Jul 2008 13:56:15 +0200, Luc <lucvdv@newsgroup.nospam> wrote: > Next thing I'm going to try (I can spare some time now) is detach my user > databases and make sure I have backup copies of the mdf and ldf, uninstall, > reinstall, get all updatees, and then re-attach my databases. > > Regardless of whether it works or not, I'll post the result somewhere in > this thread. Reinstalling SQL Server (and SP2) helped, the KB948109 update now installed as smooth as it should have all along (the automatic update, I didn't have to use the interactive one). But if each update is going to require this kind of hassle from now on, methinks I'm gonna have to put up a job sign for an update installer. BTW1: along the way I found that I had to FULLY uninstall not only SQL server, but also surrounding stuff (SQL Native Client, VSS writer), or I couldn't even get it reinstalled. Setup failed. BTW2: after my second uninstall (see BTW1), before I got around to reinstalling, something odd came up: windows update insisted that I needed the latest Office 2003 service pack. This is a clean Vista setup with Office 2007, no Office 2003 aboard. When I let it go along the SP setup reported success, but too fast to have done much. I think it didn't even create a restore point.
Guest Keith Posted July 10, 2008 Posted July 10, 2008 I acutally got this to work but here is what I had to do. Running this update downloaded as shown above by Tornalca, I noticed that when I ran it the first time it failed at an authentication point. I was logged in as the server admin as well. I just tried running it as the domain SQL server admin and it worked fine. Don't know if this will help you or not. But the local admin, and a domain user with local admin rights was not enough when it came to the database. I find that very strange. The update did complete successfully when I used the SQLadmin account however. Give that a shot I hope it helps! "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest Garth H Posted July 10, 2008 Posted July 10, 2008 I am stuck with a similar problem, which appeared when I tried to install the KB948109 -- my original SQL Express 2005 SP2 installation must have been defective. Any way it created a service MSSQL$SQLEXPRESS which would never start because of not authorized for access errors regardless of what I did to authorize the user. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If you have had an aborted install of SQL you may expect this problem. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ So I uninstalled SQL Express completely and reinstalled. However, it still found, but would not accept, the old service MSSQL$SQLEXPRESS and would only proceed if I specified "Use Default" This reinstall then went OK and reinstalled SQL Express creating a new service MSSQLSERVER. Now I applied the downloaded KB948109 as per Tornalca and it applied it successfully to the new valid service MSSQLSERVER but not to the old invalid service MSSQL$ SQLEXPRESS. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ So, how do I purge the invalid service MSSQL$SQLEXPRESS from my machine? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- RGH "Paul" wrote: > Unchecking SQL express worked for me but how do I update SQL express? > > "Mike Moore" wrote: > > > All updates installed normally except the one for Sql Server 05 above. > > Failed info provided error code 0x733F. Can't find any help references to > > that error code. Any suggestions?
Guest Randy Martin Posted July 10, 2008 Posted July 10, 2008 Your supposition about database file location clicked for me. We had a similar issue on the SP2 (or SP1?) install with the mssqlsystemresource DB. My problem was that the distmdl.mdf and distmdl.ldf were not in the same folder as master, or possibly mssqlsystemresource. I copied them there, did the automatic update, and everything was fine. "lucvdv" wrote: > I've got the problem on two machines (at least, these are the frist two I try > to update). Both have only one instance running, Express on one and > Developer Edition on the other. The manual update installer fails on both. > > Just a hunch, but could the real reason be that the database files (mdf/ldf, > not just user databases but also master etc.) are located on another harddisk > than the executables? > > In the past, even having your TEMP path on another drive then C: has been > known to make some updates fail, because the installer tries to move files > from one location to another, but to do that it's using a method that only > succeeds if source and destination locations are on the same partition. > > > > "camelx" wrote: > > > The reason for the error is that the patch tries to update both instances if > > MS SQL: SQLSERVER and SQLSERVER\EXPRESS. Usually one of these won't start > > becasue the master database files in the Data directory is compressed. SQL > > can't start the service of an instance if the master database file and log > > file are compressed. Same reason why the patch does not apply. Just > > uncompress these files, start the service for both instances and apply the > > patch. (files get compressed when disk cleanup is run!). > > > > "Mike Moore" wrote: > > > > > All updates installed normally except the one for Sql Server 05 above. > > > Failed info provided error code 0x733F. Can't find any help references to > > > that error code. Any suggestions?
Guest Alessandro Posted July 10, 2008 Posted July 10, 2008 I had the same error code but after some unsuccesful attemps I saw that some Services related to SQL_SERVER were stopped and prevented the correct installation of the update. I fixed starting up these services and relaunching the update process. Hope this will help, Alessandro "dp" wrote: > Unticking SQL Express made no difference at all. > > "Tornalca" wrote: > > > > > > When installing untick the SQL Express Instance(This is what makes it fail), > > I don't use it so do not care if this is updated. Install all the other > > updates to SQL intances. >
Guest PA Bear [MS MVP] Posted July 10, 2008 Posted July 10, 2008 From MS Support: <QP> Error: 733F-- Services Failed to Start Description: This error occurs when the installation program can’t start the SQL Server services. This can happen for several reasons including: expired account password, invalid user account, user account does not have permission to start the service, or there is something else wrong with the service. Resolution: To help you determine which service is failing to start, view the summary.txt file that is created at... %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix Once you determine which service is failing, do the following: 1. Click Start, point to Settings, and then click Control Panel. 2. Double-click Administrative Tools, and then double-click Services. 3. Locate the SQL Server service causing the problem and try to manually start the service. 4. If the service still does not start, try resetting the password or the user account. After doing this, restart the service manually More information, see: http://support.microsoft.com/kb/282254 If you need additional help, please post your summary.txt file located at %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix to the SQL Server Setup MSDN forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 </QP> -- ~Robear Dyer (PA Bear) MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002 AumHa VSOP & Admin http://aumha.net DTS-L http://dts-l.net/ Mike Moore wrote: > All updates installed normally except the one for Sql Server 05 above. > Failed info provided error code 0x733F. Can't find any help references to > that error code. Any suggestions?
Recommended Posts