Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2005 SP1 - can you please look at log file

Status
Not open for further replies.

sqlsadie108

Programmer
Feb 23, 2007
47
US
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, this is a new install and I want to make sure this is done correctly NOW. I will re-install if necessary, now, rather than later!

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.msi
02/23/2007 14:51:56.156 Creating MSI install log file at: C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.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.msi
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
 
I should also mention, I neglected to reboot after the initial SQL Server 2005 installation, before the service pack installation.

I did encounter some errors during the SP1 install, locked files causing problems. So I hit cancel several times, but the SP1 installer proceeded anyways. When I was done, several entries showed "cancelled".

Then, I rebooted, and reapplied SP1. Everything showed "success" the second time around. The log file I printed is from the second installation.

Thanks
 
The log looks fine to me.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
The "problem" was, this is just one log of many... to see the entire SP1 hotfix log you have to look at c:\windows\hotfix.log, etc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top