Guest Tritous Posted September 3, 2008 Posted September 3, 2008 Well after reading the KB article about problems with repeatedly installing the same update (and finding it unhelpful), sending a mail to MS customer support (and getting back a blank response and a link to the KB, not even to an article, just generally to the support webside which is an insult) I come here hoping someone has an answer. Security Update for SQL Server 2005 Service Pack 2 (KB948109) Well it's been installed about 6 times now. 4 times through automatic updates, 2 times through the updates website and each time has suceeded. However, it still isnt registering that it is installed and still wants it. I suspect the downloaded file may be corrupted, but since it is already downloaded, neither the website or update service try redownloading it, and while I'm experienced in general usage, repair and maintainance of my pc, I've never found it easy to locate anything MS (it's always hidden under a cryptic name in a cryptic folder with a thousand other things I don't want to delete by accident) Looking around here I've tried clearing the catroot folders but that had no affect. When the data was sent to microsoft support (lot of good that did) I read through all the compiles and logs and found some interesting info at least. When it is installing it seems to be registering that the files are already there (so it doesnt overwrite) and since no files have been changed, it logs it as not having had to update anything. At least, that is what I managed to derive from the mess of the log. Any help and advice would be appreciated. My first step would be to delete the downloaded installers in case they are corrupted. I did recently suffer my worst spyware attack in about 7 years, I've cleaned up with 2 antispywares, an antivirus, and several manual sweeps through registry returning things to as they were (I know my computer well enough to remember at least). I'm confident but not certain that all is fixed, so if there is a possibility that it is simply a wrong registry entry not logging that the update has completed, advice on where in the registry to look would be helpful. For reference: XP Pro with SP3 and the works re: updates, at least until this one I'm very familar with most of the basic admin tools, services, registry, but only know a moderate number of networking shell commands, and so have never learnt the commands for various reinitialisations of services or DLLs. I am happy enough to use them of course, so it shouldnt be a problem fixing once the cause is found.
Guest Thee Chicago Wolf Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 >Well after reading the KB article about problems with repeatedly installing >the same update (and finding it unhelpful), sending a mail to MS customer >support (and getting back a blank response and a link to the KB, not even to >an article, just generally to the support webside which is an insult) I come >here hoping someone has an answer. > >Security Update for SQL Server 2005 Service Pack 2 (KB948109) > >Well it's been installed about 6 times now. 4 times through automatic >updates, 2 times through the updates website and each time has suceeded. >However, it still isnt registering that it is installed and still wants it. > >I suspect the downloaded file may be corrupted, but since it is already >downloaded, neither the website or update service try redownloading it, and >while I'm experienced in general usage, repair and maintainance of my pc, >I've never found it easy to locate anything MS (it's always hidden under a >cryptic name in a cryptic folder with a thousand other things I don't want to >delete by accident) > >Looking around here I've tried clearing the catroot folders but that had no >affect. When the data was sent to microsoft support (lot of good that did) I >read through all the compiles and logs and found some interesting info at >least. When it is installing it seems to be registering that the files are >already there (so it doesnt overwrite) and since no files have been changed, >it logs it as not having had to update anything. At least, that is what I >managed to derive from the mess of the log. > >Any help and advice would be appreciated. My first step would be to delete >the downloaded installers in case they are corrupted. I did recently suffer >my worst spyware attack in about 7 years, I've cleaned up with 2 >antispywares, an antivirus, and several manual sweeps through registry >returning things to as they were (I know my computer well enough to remember >at least). I'm confident but not certain that all is fixed, so if there is a >possibility that it is simply a wrong registry entry not logging that the >update has completed, advice on where in the registry to look would be >helpful. > >For reference: >XP Pro with SP3 and the works re: updates, at least until this one >I'm very familar with most of the basic admin tools, services, registry, but >only know a moderate number of networking shell commands, and so have never >learnt the commands for various reinitialisations of services or DLLs. I am >happy enough to use them of course, so it shouldnt be a problem fixing once >the cause is found. To install a service pack for SQL Server, it typically requires an SQL Admin password to be applied. - Thee Chicago Wolf
Guest Tritous Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 Naturally I wouldnt log on with anything less than admin rights. Having limited rights on my own PC makes me itchy. In all honesty I debate at times why I even bother having the SQL server since it's not something I personally use and I don't directly know of any of my programs which use it. However that's just it, one of them just may use it on rare occassions so I need it there. If it has it's own admin password I cetainly don't know about it. "Thee Chicago Wolf" wrote: > > To install a service pack for SQL Server, it typically requires an SQL > Admin password to be applied. > > - Thee Chicago Wolf >
Guest Thee Chicago Wolf Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 >Naturally I wouldnt log on with anything less than admin rights. Having >limited rights on my own PC makes me itchy. In all honesty I debate at times >why I even bother having the SQL server since it's not something I personally >use and I don't directly know of any of my programs which use it. However >that's just it, one of them just may use it on rare occassions so I need it >there. If it has it's own admin password I cetainly don't know about it. Judging from the sound of your answer, it seems like you might have the lite version of SQL 2005 installed called Express Edition. If you have SQL Server 2005, when it was installed, it would have prompted for an SQL Admin password for sure. I know it's probably annoying to keep seeing this update appear over and over so perhaps try manually updating it. The patch is locate here: http://www.microsoft.com/downloads/details.aspx?familyid=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en The file would be: SQLServer2005SP2-KB921896-x86-ENU.exe. - Thee Chicago Wolf
Guest PA Bear [MS MVP] Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 North America only: "Please call 1-800-936-4900 and open a case and ask to be routed to the SQL-Public Team. There is no charge for this case as it has to do with a Security Bulletin. "When you call please let them know that this has to do with Security Bulletin MS08-040. "If they try to charge you, please let them know that there is free support for any issues with Security Updates." Source: http://groups.google.com/group/microsoft.public.windowsupdate/msg/05fc180d9f9e71b9 -- ~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/ Tritous wrote: > Well after reading the KB article about problems with repeatedly > installing > the same update (and finding it unhelpful), sending a mail to MS customer > support (and getting back a blank response and a link to the KB, not even > to > an article, just generally to the support webside which is an insult) I > come > here hoping someone has an answer. > > Security Update for SQL Server 2005 Service Pack 2 (KB948109) > > Well it's been installed about 6 times now. 4 times through automatic > updates, 2 times through the updates website and each time has suceeded. > However, it still isnt registering that it is installed and still wants > it. > > I suspect the downloaded file may be corrupted, but since it is already > downloaded, neither the website or update service try redownloading it, > and > while I'm experienced in general usage, repair and maintainance of my pc, > I've never found it easy to locate anything MS (it's always hidden under a > cryptic name in a cryptic folder with a thousand other things I don't want > to delete by accident) > > Looking around here I've tried clearing the catroot folders but that had > no > affect. When the data was sent to microsoft support (lot of good that > did) > I read through all the compiles and logs and found some interesting info > at > least. When it is installing it seems to be registering that the files > are > already there (so it doesnt overwrite) and since no files have been > changed, > it logs it as not having had to update anything. At least, that is what I > managed to derive from the mess of the log. > > Any help and advice would be appreciated. My first step would be to > delete > the downloaded installers in case they are corrupted. I did recently > suffer > my worst spyware attack in about 7 years, I've cleaned up with 2 > antispywares, an antivirus, and several manual sweeps through registry > returning things to as they were (I know my computer well enough to > remember > at least). I'm confident but not certain that all is fixed, so if there > is > a possibility that it is simply a wrong registry entry not logging that > the > update has completed, advice on where in the registry to look would be > helpful. > > For reference: > XP Pro with SP3 and the works re: updates, at least until this one > I'm very familar with most of the basic admin tools, services, registry, > but > only know a moderate number of networking shell commands, and so have > never > learnt the commands for various reinitialisations of services or DLLs. I > am > happy enough to use them of course, so it shouldnt be a problem fixing > once > the cause is found.
Guest Tritous Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 Unfortunately I'm in UK, and the uk numbers for the support are on high charge numbers, certainly not freephone. I forgot to mention that. And yeah, I do have SQL express (and I believe it has SP2 already on it) Looking way futher back in my updates, it's starting to look like this update did try and fail nearly a month ago, I wonder if that is the cause of all this. Any tips on how to uninstall an update that windows hasn't figured out has been installed? "PA Bear [MS MVP]" wrote: > North America only: > > "Please call 1-800-936-4900 and open a case and ask to be routed to the > SQL-Public Team. There is no charge for this case as it has to do with a > Security Bulletin. > > "When you call please let them know that this has to do with Security > Bulletin MS08-040. > > "If they try to charge you, please let them know that there is free support > for any issues with Security Updates." > > Source: > http://groups.google.com/group/microsoft.public.windowsupdate/msg/05fc180d9f9e71b9 > -- > ~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/ > > > Tritous wrote: > > Well after reading the KB article about problems with repeatedly > > installing > > the same update (and finding it unhelpful), sending a mail to MS customer > > support (and getting back a blank response and a link to the KB, not even > > to > > an article, just generally to the support webside which is an insult) I > > come > > here hoping someone has an answer. > > > > Security Update for SQL Server 2005 Service Pack 2 (KB948109) > > > > Well it's been installed about 6 times now. 4 times through automatic > > updates, 2 times through the updates website and each time has suceeded. > > However, it still isnt registering that it is installed and still wants > > it. > > > > I suspect the downloaded file may be corrupted, but since it is already > > downloaded, neither the website or update service try redownloading it, > > and > > while I'm experienced in general usage, repair and maintainance of my pc, > > I've never found it easy to locate anything MS (it's always hidden under a > > cryptic name in a cryptic folder with a thousand other things I don't want > > to delete by accident) > > > > Looking around here I've tried clearing the catroot folders but that had > > no > > affect. When the data was sent to microsoft support (lot of good that > > did) > > I read through all the compiles and logs and found some interesting info > > at > > least. When it is installing it seems to be registering that the files > > are > > already there (so it doesnt overwrite) and since no files have been > > changed, > > it logs it as not having had to update anything. At least, that is what I > > managed to derive from the mess of the log. > > > > Any help and advice would be appreciated. My first step would be to > > delete > > the downloaded installers in case they are corrupted. I did recently > > suffer > > my worst spyware attack in about 7 years, I've cleaned up with 2 > > antispywares, an antivirus, and several manual sweeps through registry > > returning things to as they were (I know my computer well enough to > > remember > > at least). I'm confident but not certain that all is fixed, so if there > > is > > a possibility that it is simply a wrong registry entry not logging that > > the > > update has completed, advice on where in the registry to look would be > > helpful. > > > > For reference: > > XP Pro with SP3 and the works re: updates, at least until this one > > I'm very familar with most of the basic admin tools, services, registry, > > but > > only know a moderate number of networking shell commands, and so have > > never > > learnt the commands for various reinitialisations of services or DLLs. I > > am > > happy enough to use them of course, so it shouldnt be a problem fixing > > once > > the cause is found. > >
Guest Thee Chicago Wolf Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 >Unfortunately I'm in UK, and the uk numbers for the support are on high >charge numbers, certainly not freephone. I forgot to mention that. > >And yeah, I do have SQL express (and I believe it has SP2 already on it) > >Looking way futher back in my updates, it's starting to look like this >update did try and fail nearly a month ago, I wonder if that is the cause of >all this. Any tips on how to uninstall an update that windows hasn't figured >out has been installed? Might be easier to run Windows Update and if you see that update, explode the [+] box and check the box beneath that says "Don't show this update again". I have seen this happen even if the update has already been installed. Sometimes WU doesn't recognize the installed update as existing and continues to pester you and / or fail. - Thee Chicago Wolf
Guest Tritous Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 well now I'm stuck with the warning of "you have hidden high priority updates", but I can live with that. Perhaps not the most elegant solution, but it does the job I guess lol. Cheers I do hope it has actually installed properly, although I'm somewhat tempted just to remove the sql server entirely "Thee Chicago Wolf" wrote: > >Unfortunately I'm in UK, and the uk numbers for the support are on high > >charge numbers, certainly not freephone. I forgot to mention that. > > > >And yeah, I do have SQL express (and I believe it has SP2 already on it) > > > >Looking way futher back in my updates, it's starting to look like this > >update did try and fail nearly a month ago, I wonder if that is the cause of > >all this. Any tips on how to uninstall an update that windows hasn't figured > >out has been installed? > > Might be easier to run Windows Update and if you see that update, > explode the [+] box and check the box beneath that says "Don't show > this update again". I have seen this happen even if the update has > already been installed. Sometimes WU doesn't recognize the installed > update as existing and continues to pester you and / or fail. > > - Thee Chicago Wolf >
Guest PA Bear [MS MVP] Posted September 3, 2008 Posted September 3, 2008 Re: Automatic Updates repeatedly installing KB948109 See the "Known issues with this security update" and "How to obtain help and support for this security update" sections of http://support.microsoft.com/kb/941203 [Try the Irish support phone number: One hears it's free.] -- ~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/ Tritous wrote: > Unfortunately I'm in UK, and the uk numbers for the support are on high > charge numbers, certainly not freephone. I forgot to mention that. > > And yeah, I do have SQL express (and I believe it has SP2 already on it) > > Looking way futher back in my updates, it's starting to look like this > update did try and fail nearly a month ago, I wonder if that is the cause > of > all this. Any tips on how to uninstall an update that windows hasn't > figured out has been installed? > > "PA Bear [MS MVP]" wrote: > >> North America only: >> >> "Please call 1-800-936-4900 and open a case and ask to be routed to the >> SQL-Public Team. There is no charge for this case as it has to do with a >> Security Bulletin. >> >> "When you call please let them know that this has to do with Security >> Bulletin MS08-040. >> >> "If they try to charge you, please let them know that there is free >> support >> for any issues with Security Updates." >> >> Source: >> http://groups.google.com/group/microsoft.public.windowsupdate/msg/05fc180d9f9e71b9 >> -- >> ~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/ >> >> >> Tritous wrote: >>> Well after reading the KB article about problems with repeatedly >>> installing >>> the same update (and finding it unhelpful), sending a mail to MS >>> customer >>> support (and getting back a blank response and a link to the KB, not >>> even >>> to >>> an article, just generally to the support webside which is an insult) I >>> come >>> here hoping someone has an answer. >>> >>> Security Update for SQL Server 2005 Service Pack 2 (KB948109) >>> >>> Well it's been installed about 6 times now. 4 times through automatic >>> updates, 2 times through the updates website and each time has suceeded. >>> However, it still isnt registering that it is installed and still wants >>> it. >>> >>> I suspect the downloaded file may be corrupted, but since it is already >>> downloaded, neither the website or update service try redownloading it, >>> and >>> while I'm experienced in general usage, repair and maintainance of my >>> pc, >>> I've never found it easy to locate anything MS (it's always hidden under >>> a >>> cryptic name in a cryptic folder with a thousand other things I don't >>> want >>> to delete by accident) >>> >>> Looking around here I've tried clearing the catroot folders but that had >>> no >>> affect. When the data was sent to microsoft support (lot of good that >>> did) >>> I read through all the compiles and logs and found some interesting info >>> at >>> least. When it is installing it seems to be registering that the files >>> are >>> already there (so it doesnt overwrite) and since no files have been >>> changed, >>> it logs it as not having had to update anything. At least, that is what >>> I >>> managed to derive from the mess of the log. >>> >>> Any help and advice would be appreciated. My first step would be to >>> delete >>> the downloaded installers in case they are corrupted. I did recently >>> suffer >>> my worst spyware attack in about 7 years, I've cleaned up with 2 >>> antispywares, an antivirus, and several manual sweeps through registry >>> returning things to as they were (I know my computer well enough to >>> remember >>> at least). I'm confident but not certain that all is fixed, so if there >>> is >>> a possibility that it is simply a wrong registry entry not logging that >>> the >>> update has completed, advice on where in the registry to look would be >>> helpful. >>> >>> For reference: >>> XP Pro with SP3 and the works re: updates, at least until this one >>> I'm very familar with most of the basic admin tools, services, registry, >>> but >>> only know a moderate number of networking shell commands, and so have >>> never >>> learnt the commands for various reinitialisations of services or DLLs. >>> I >>> am >>> happy enough to use them of course, so it shouldnt be a problem fixing >>> once >>> the cause is found.
Guest Tritous Posted September 4, 2008 Posted September 4, 2008 Re: Automatic Updates repeatedly installing KB948109 A couple of interesting notes on that article, although I'd tried restarting the service already I have no access to a phone which can support international numbers and while it may be free in Ireland, the charge to call an Irish number from UK still appies. I did follow the help and support prior to coming here and sent a mail with attached data. The reply came with 4 blank fields, a link to the MS KB (not even to an article, just to it's home) and a 0870 number, which is a higher rate UK number. The little of relevence was clearly just part of the standardised and uncompleted mail structure. Actually the little of relevence only consisted of the link, number, and the title of the mail I sent them. The idea of a 15 minutes of automessages, 20 minutes on hold just to get given no useful answer on a high charge call doesnt appeal at all I wish that could be called cynical but it's to justified. Times like this the advice of real people is more useful than someone who has been in an office for 10 hours answering daft questions and getting generally demoralised. "PA Bear [MS MVP]" wrote: > See the "Known issues with this security update" and "How to obtain help and > support for this security update" sections of > http://support.microsoft.com/kb/941203 > > [Try the Irish support phone number: One hears it's free.] > -- > ~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/ > >>
Guest PA Bear [MS MVP] Posted September 4, 2008 Posted September 4, 2008 Re: Automatic Updates repeatedly installing KB948109 [Crossposted to WU newsgroup] Not much else I can suggest other than the following. If you can reach US/CA-based toll free numbers using your mobile or Skype, call 1-800-936-5700 and pretend that you're in the US or CA. Identify your SQL Server version/build in the chart under "Known issues with this security update" in http://support.microsoft.com/kb/941203 and check the related KB article (e.g., http://support.microsoft.com/kb/957008/; http://support.microsoft.com/kb/953742/). -- ~PA Bear Tritous wrote: > A couple of interesting notes on that article, although I'd tried > restarting > the service already > > I have no access to a phone which can support international numbers and > while it may be free in Ireland, the charge to call an Irish number from > UK > still appies. I did follow the help and support prior to coming here and > sent a mail with attached data. The reply came with 4 blank fields, a > link > to the MS KB (not even to an article, just to it's home) and a 0870 > number, > which is a higher rate UK number. The little of relevence was clearly > just > part of the standardised and uncompleted mail structure. Actually the > little of relevence only consisted of the link, number, and the title of > the mail I sent them. The idea of a 15 minutes of automessages, 20 > minutes > on hold just to get given no useful answer on a high charge call doesnt > appeal at all > > I wish that could be called cynical but it's to justified. Times like > this > the advice of real people is more useful than someone who has been in an > office for 10 hours answering daft questions and getting generally > demoralised. > > > "PA Bear [MS MVP]" wrote: >> See the "Known issues with this security update" and "How to obtain help >> and support for this security update" sections of >> http://support.microsoft.com/kb/941203 >> >> [Try the Irish support phone number: One hears it's free.] >> -- >> ~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/
Guest Harry Johnston [MVP] Posted September 5, 2008 Posted September 5, 2008 Re: Automatic Updates repeatedly installing KB948109 Tritous wrote (crossposted to WU newsgroup by PA Bear [MS MVP]): > A couple of interesting notes on that article, although I'd tried restarting > the service already I haven't seen all of the history to this thread, since I don't monitor windowsxp.general. I assume you've already tried downloading the update and installing it by hand; have you tried creating a new administrative account (one local to the computer rather than a domain account) and using the new account to install the downloaded update? There have been several updates lately which are oversensitive to the context in which they are being run, and I suspect this might be one of them - creating a brand new user gives you a clean user registry and using a local account keeps any user group policy from interfering. It may be worth a try, anyway. Harry.
Guest Tritous Posted September 5, 2008 Posted September 5, 2008 Re: Automatic Updates repeatedly installing KB948109 Well I have tried installing using my normal user account (which is a power user) and using the stock Administrator account which I never bothered using before. Main reason I tried that account at all is because of a bugged GFX driver update having complaints over admin rights falsely. That's interesting to note and I'll remember it in future issues too as an option worth trying. Afterall, since I don't use the stock Administrator account it is clean enough. I've checked all the KB articles suggested so far, they haven't solved the problem. Only thing so far to make a difference was to just hide notifications of that particular update. "Harry Johnston [MVP]" wrote: > Tritous wrote (crossposted to WU newsgroup by PA Bear [MS MVP]): > > > A couple of interesting notes on that article, although I'd tried restarting > > the service already > > I haven't seen all of the history to this thread, since I don't monitor > windowsxp.general. I assume you've already tried downloading the update and > installing it by hand; have you tried creating a new administrative account (one > local to the computer rather than a domain account) and using the new account to > install the downloaded update? > > There have been several updates lately which are oversensitive to the context in > which they are being run, and I suspect this might be one of them - creating a > brand new user gives you a clean user registry and using a local account keeps > any user group policy from interfering. It may be worth a try, anyway. > > Harry. >
Recommended Posts