Windows Update Fails and won't go away
I had installed SQL Server 2005 developer on my machine (Vista 64-bit) prior to installing Visual Studio 2005. When I installed VS, I used the default installation, which installed SQL Server Express. Soon thereafter, I started getting notifications in Windows Update about an update to SP2. However, when I try to install it, it fails with "Code 7367", and provides no other useful information. I tried downloading SQL Server Express SP2 myself but it would not let me update the existing instance on my machine. So I totally removed the instance from my machine through add/remove. However, I restarted and the update is still showing up and won't go away!! Does anybody have any ideas of getting this problem?
All Replies
Cannot speak for Vista, I'm too chicken to install it just yet, but I ran into a similar problem after installing VS2005 under XP and I found a way to get rid of it. I already had an instance of SQL Express installed, so I did not initially re-install SSE. I had a VC# Express 2005 installed but I deleted it prior to installing VS2005 SE.
In short, check what updates were installed after installed VS2005. (This sounds odd but the best I came up with is that Visual Studio was calling for SQL to be updated after VS had been updated.)
After I installed VS, I dutifully performed Windows Updates on it. VS updated itself. SSE was already updated prior to installation. How did I fix it? I deleted the VS upgrades and my SSE completely. I re-installed SSE, and then performed the updates on both. IT WORKED! Hope this helps.
Rudedog
"Fooling computers since 1971."
Hi did you figure out the code 7367 vista update error? (Microsoft SQL server 2005 Express Edition SP2? I have same issue.
Nope.. I gave up, and still have Windows Update constantly pestering me to install it.. Sorry.Did you try deleting everything and starting over?
This whole SP2 thing can get confusing for itself, because there are multiple components that need an "SP2" update. If they are performed out of order, the OS seems to get locked into a loop. It thinks it needs it, but it fails on the install because now it thinks it does not need it.
I also suggest always performing manual updates to Windows, by selecting CUSTOM, not Express update. Automatic updates seems to only perform "critical" updates to the software. That means that a lot of updates are overlooked and ignored when you allow the system to auto-update itself. Result, confusion.
Rudedog
The most common cause of having a persisiten notification for SQL Express SP2 is that you have ACT! installed on your computer. ACT! installs it's own copy of SQL Express and configures it in a way that breaks service pack installation (both manual and automated). The only way to apply the update to the ACT! instances is to follow the instructions on their web site for use of their special installer: ACT! KB article.
If you don't have ACT! installed, you should check the setup logs to determine the cause of the error, you can find them at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix, check the Summary.txt log first for an overview of what is happening. Summary will point you to a specific log file.
Regards,
Mike
I don't have ACT!
I ran the setup and hunted through the log files. In one of the log files, SQLSetup0013_CORYB_Tools.log, I found the following:
*********************************************************************
Condition "installActionAvailable_maintenance_{FE7C8861-3195-4CA5-98EB-094652478192}_Tools_Legacy" returned false.
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlca\upgradeproduct.cpp
Compiler Timestamp: Wed Jun 14 16:27:13 2006
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 143---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resourcesError Code: 29543
MSI (s) (08!F8) [15:35:54:859]: Product: Microsoft SQL Server 2005 Tools Express Edition -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Failure Type='Fatal' Error='29543'>
<EndFunc Name='LaunchFunction' Return='29543' GetLastError='203'>
Action ended 15:35:54: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 15:35:54: INSTALL. Return value 3.*********************************************************************
SQLSetup0013_CORYB_Core(Local).log appears to contain logs for a script which invoked the Tools installer:
*********************************************************************
Running: InstallToolsAction at: 7d8/0/7 f:23:25
Installing: tools on target: CORYB
Failed to install package
Fatal error during installation.
Setting package return code to: 7367
Complete: InstallToolsAction at: 7d8/0/7 f:23:37, returned false
Error: Action "InstallToolsAction" failed during execution. Error information reported during run:
Target collection includes the local machine.*********************************************************************
I still do not know how to fix this problem.
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. This line suggests that the SQL Tools on your computer are not from Express edition and therefore can not be upgraded by Express edition.
The SQL Tools are a shared component across all editions of SQL Server, each edition installs a larger set of tools, and you can only upgrade the tools with the patch for the edition which installed your tools. The best way to figure out if this is the case is to check out which edition your tools claim to be part of in Add/Remove programs:
-
Open Add/Remove Programs.
-
Select Microsoft SQL Server 2005 and click Change.
-
Click the Report button.
-
Highlight everything in the Report windows and copy it using CTRL+C.
-
Paste the results into your response.
-
Close down the SQL Server mainentence windows.
While you're in Add/Remove Programs, take a look and see if you have a listing for SQL Server Managment Studio Express.
Thanks,
Mike
-
Mike,
I realize I don't have SQL Server Express anymore, but Windows Update continues to pester me to install the update despite the fact that it won't install and doesn't even apply to my system anymore.
I had installed SQL Server Developer prior to installing Visual Studio. When I installed Visual Studio, it installed SQL Server Express because I did not modify the default installation options. At that point, I started getting the notification that the SSE update was available. However, when I would attempt to install it, it would fail. The original SQL Server Developer installation was interfering with it somehow. After uninstalling SSE, the update notification won't go away, so I am stuck with it constantly badgering me to install it.
Cory
I just noticed an option to hide the update in Windows Update by right-clicking. That seems to fix the nagging.
Hi Cory,
Yes, that will stop the nagging, but if you were getting the warning in the first place, you did not fully uninstall SQL Express. There must be some piece of it still there if Microsoft Update is findinging it. The Report screen in Add/Remove Programs will show you all the components installed and indicate what edition it comes from, you might want to check to see if any of them list Express as the source.
Regards,
Mike
This damn thing is so annoying. Just let you guys know, I downloaded and fully installed SQL 2005 Express from Microsoft trying to get rid of the update nagging. However, it still there!
ysm79 wrote: This damn thing is so annoying. Just let you guys know, I downloaded and fully installed SQL 2005 Express from Microsoft trying to get rid of the update nagging. However, it still there!
What combination of packages and OS are you talking about?
Okay you re-installed and still have problems, but did you un-install anything first? Try un-installing all of the SP2 updates for VS and SQL. For SQL that might mean deleting in and re-installing it.
As I said above, un-install until the messages ago away. UPDATE Windows FIRST. Still clean? Then try to install the applications.
- I have the same problem and hiding doesn't work. It just perpetually nags. I guess I'll have to live with it. Glad I have XP on my notebook. I'm never "upgrading" that.
