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.

>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

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
>

>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/d...displaylang=en

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

- Thee Chicago Wolf

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/micro...fc180d9f9e71b9
--
~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.

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/micro...fc180d9f9e71b9
> --
> ~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.
>
>

>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

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
>

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/micro...fc180d9f9e71b9
>> --
>> ~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.

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