Automatic Updates repeatedly installing KB948109

[Guest Tritous]

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]

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]

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]

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]]

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]

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]

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]

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]]

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]

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]]

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]]

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]

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.

>