472,351 Members | 1,473 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,351 software developers and data experts.

Help, did SP1 install work?? SQL Server 2005

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

Feb 23 '07 #1
1 3301
(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
Feb 24 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dmitry Demchuk | last post by:
Hi everybody. Recently I ran into situation with System.Threading.Timer in my ASP.NET application. I reinstalled Windows on one of my servers and...
11
by: scorpion53061 | last post by:
I have a request of Microsoft and I hope they see this. I use Visual Studio 2005 Pro and WIN XP Pro with IIS 5.1 I have spent the better part...
3
by: pine | last post by:
hi! i just joined this group today after a colleague told me about it. anyway, i'm new to SQL and haven't tried installing any version of it. I do...
0
by: Nattydreadlock | last post by:
Hello, I'm having some problems installing Visual Studio 2005. I'll briefly explain what's the history of the problem here. First I installed...
15
by: Jay | last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM...
3
by: danofweaver | last post by:
How can I practice the use of SQL server without changing my girlfriends laptop to XP Pro (which anyway I dont have)? Using (unfortunately) Windows...
1
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am...
4
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.