Posted by Erland Sommarskog on 02/24/07 10:45

(kataoki@gmail.com) writes:
> This is the log file for my SP1 on 2005 install. Can anyone please
> look at this and tell me if this looks normal?
>
> I'm concerned about the following in the log:
> "Failed to read registry key: Debug"

This one may be innocent. My speculation is that it's looking for for this
registry key, which if present will alter the execution path, presumably
to enable some debugging.

> AND
> all the entries that show "- Not Applied"

I would interpret that as the service pack was not applied for anything
but SQL Native Client.

> According to SELECT SERVERPROPERTY('ProductLevel') my service pack is
> "SP1", so everything appears "normal".

What does does SELECT @@version say?

If you look at
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
(or corresponding), what size and date information do you see?

> However, I had to apply the service pack a couple times because the
> first try gave "locked files" error. I did not reboot after the
> initial SQL Server 2005 installation, which I think may have caused a
> problem, but I don't know. I reapplied the SP1 two more times after
> the reboot. This is the log file from the third try (the second log
> file looked identical).

Obviously it's not applying SP1, if you are already there. Then again
it says:

> 02/23/2007 14:51:57.574 Product: Database Services
> 02/23/2007 14:51:57.590 Database Services (RTM 1399 ENU) -

Which seems that you had the RTM version and not SP1.

Anyway, SP2 two is out, so the easy way out, may be to download and
install SP2.

--
Erland Sommarskog, SQL Server MVP, esquel@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

[Back to original message]