Help, did SP1 install work?? SQL Server 2005

[kataoki]

Hi,

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"
AND
all the entries that show "- Not Applied"

What does this mean?

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

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

THANKS
02/23/2007 14:51:31.778
================================================== ==============================
02/23/2007 14:51:31.778 Hotfix package launched
02/23/2007 14:51:56.077 Attempting to install instance: SQL Server
Native Client
02/23/2007 14:51:56.077 Attempting to install target: SQL1
02/23/2007 14:51:56.109 Attempting to install file: sqlncli.msi
02/23/2007 14:51:56.140 Attempting to install file: \\SQL1\l$
\a08e113ab889fa7a0b\HotFixSqlncli\Files\sqlncli.ms i
02/23/2007 14:51:56.156 Creating MSI install log file at: C:\WINDOWS
\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlnc li.msi.log
02/23/2007 14:51:56.172 Successfully opened registry key: Software
\Policies\Microsoft\Windows\Installer
02/23/2007 14:51:56.188 Failed to read registry key: Debug
02/23/2007 14:51:57.228 MSP returned 0: The action completed
successfully.
02/23/2007 14:51:57.322 Successfully opened registry key: Software
\Policies\Microsoft\Windows\Installer
02/23/2007 14:51:57.338 Failed to read registry key: Debug
02/23/2007 14:51:57.354 Successfully installed file: \\SQL1\l$
\a08e113ab889fa7a0b\HotFixSqlncli\Files\sqlncli.ms i
02/23/2007 14:51:57.369 Successfully installed target: SQL1
02/23/2007 14:51:57.401 Successfully installed instance: SQL Server
Native Client
02/23/2007 14:51:57.417
02/23/2007 14:51:57.432 Product Status Summary:
02/23/2007 14:51:57.448 Product: SQL Server Native Client
02/23/2007 14:51:57.480 SQL Server Native Client (RTM ) -
Success
02/23/2007 14:51:57.495
02/23/2007 14:51:57.511 Product: Setup Support Files
02/23/2007 14:51:57.527 Setup Support Files (RTM ) - Not
Applied
02/23/2007 14:51:57.543
02/23/2007 14:51:57.574 Product: Database Services
02/23/2007 14:51:57.590 Database Services (RTM 1399 ENU) -
Not Applied
02/23/2007 14:51:57.606
02/23/2007 14:51:57.622 Product: Notification Services
02/23/2007 14:51:57.637 Notification Services (RTM 1399
ENU) - Not Applied
02/23/2007 14:51:57.669
02/23/2007 14:51:57.685 Product: Integration Services
02/23/2007 14:51:57.700 Integration Services (RTM 1399 ENU)
- Not Applied
02/23/2007 14:51:57.716
02/23/2007 14:51:57.732 Product: Client Components
02/23/2007 14:51:57.748 Client Components (RTM 1399 ENU) -
Not Applied
02/23/2007 14:51:57.748
02/23/2007 14:51:57.763 Product: MSXML 6.0 Parser
02/23/2007 14:51:57.779 MSXML 6.0 Parser (RTM ) - Not
Applied
02/23/2007 14:51:57.795
02/23/2007 14:51:57.811 Product: SQLXML4
02/23/2007 14:51:57.826 SQLXML4 (RTM ) - Not Applied
02/23/2007 14:51:57.842
02/23/2007 14:51:57.842 Product: Backward Compatibility
02/23/2007 14:51:57.858 Backward Compatibility (RTM ) - Not
Applied
02/23/2007 14:51:57.874
02/23/2007 14:51:57.889 Product: Microsoft SQL Server VSS Writer
02/23/2007 14:51:57.905 Microsoft SQL Server VSS Writer
(RTM ) - Not Applied
02/23/2007 14:51:57.905

[Erland Sommarskog]

(ka*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx