You are not the first to get problems with this update. To start with, which OS do you have? Next, how far to do you get in the update before it
dies? Does it stop immediately, or does it run for some time? A trivial
question: have you checked that you have not run out of disk space? (When I
ran the corresponding update for SQL 2005 at home, I got a similar cryptic
error code, and I eventually found that my disk was full.)
Note that if you are using Reporting Services, that there is a more
recent update for a more critical issue, see
http://www.microsoft.com/technet/security/Bulletin/MS08-052.mspx and
http://www.microsoft.com/downloads/details.aspx?familyid=5F9E7F78-7439-414B-A9DC-A779B89427DB
(Readers who are using SQL 2005 should be aware of that this vulnerability
affects SQL 2005 as a whole.)
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Hm, not really sure what v.1 and v.2 refers to. The KB article you mention
is for Office. 052 covers a broad range of products, not only SQL Server.
> MS08-040 downloads but wont install. It starts and almost immed. stops and
> wont install. Need more help, please.
I'm afraid that the only recommendation I can give is to open a case with
Microsoft. I was told that since this is an issue with a security update,
the case should come at no cost. As I mentioned, quite a few people has
run into this, but in most cases it has not been resolved. What I know
about is:
o Running out of disk space.
o Trying to run the update on Vista (which is not supported)
o Trying to run the update with sa, because you have removed
BUILTIN\Administrators also fails. (But it fails in a different way
than an obscure error code.)
If you really want to avoid a call to Microsoft, you could hunt your
disk for log files, and see if you can find any clue.
Good question. I guess pressing the Search button Explorer and then search
for *.log and then trawl through the fairly long list of files you will
get.
> What do you mean by run the update using sa??
If you had come that far, you would have gotten a question on how to
authenticate to SQL Server. (It doesn't seem that you reach that dialogue.)
In any case, don't try it. It doesn't work. (But it should work.)
> Sorry for the dumb questions but it is the only way to learn.
I think those who have to learn in this case is Microsoft which should not
put out a security update which you cannot install. Or at least can't give
a good explanation to why it cannot be installed.
By the way, when you run SELECT @@version in Query Analyzer, what does it
say?
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx