Automatic Updates repeatedly installing KB948109

T

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.
 
T

Thee Chicago Wolf

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
 
T

Tritous

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.
 
T

Thee Chicago Wolf

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/...b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

The file would be: SQLServer2005SP2-KB921896-x86-ENU.exe.

- Thee Chicago Wolf
 
P

PA Bear [MS MVP]

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
 
T

Tritous

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?
 
T

Thee Chicago Wolf

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
 
T

Tritous

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 said:
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
 
T

Tritous

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 said:
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/
 
P

PA Bear [MS MVP]

[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

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 said:
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/
 
H

Harry Johnston [MVP]

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.
 
T

Tritous

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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems installing KB948109 5
Windows 10 Microsoft updates HELP 5
How To Control Windows Updates? 9
Automatic Updates 3
installing updates. Never ends 2
Strange Update 6
Office 2003 on Win7 Pro - also XP 10
Installing Updates Message 2

Top