473,895 Members | 2,560 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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$
\a08e113ab889fa 7a0b\HotFixSqln cli\Files\sqlnc li.msi
02/23/2007 14:51:56.156 Creating MSI install log file at: C:\WINDOWS
\Hotfix\Redist9 \Logs\Redist9_H otfix_KB913090_ sqlncli.msi.log
02/23/2007 14:51:56.172 Successfully opened registry key: Software
\Policies\Micro soft\Windows\In staller
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\Micro soft\Windows\In staller
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$
\a08e113ab889fa 7a0b\HotFixSqln cli\Files\sqlnc li.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

Feb 23 '07 #1
1 3388
(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\sqls ervr.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****@sommarsk og.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
1790
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 got timers stop firing events after while, they just stop functioning one-by-one. Here is detailed explanation. I run application on 2 dedicated Win 2003 servers. Server A serves about 1000 active simultaneous users (150-200 aspx page requests per second), Sever B serves about 400 users (80-100...
11
1371
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 of the last 2 weeks attempting to get my ASP.NET projects to work. Just a simple hello world. Since installing the 2.0 of the framework, localhost no longer works on IIS. localhost is required for (at least it appears so) for the ASP.NET development server to function. Actually I take that...
3
3196
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 have vb 6.0 though on my pc. My problem is that I can't install SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the installer from the Microsoft site as well as the dotnetfix which is supposed to install the .net framework 2.0. whenever i try to install SQL server EE, it is...
0
2421
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 VS 2005 beta 2. I uninstalled it later via the Windows Uninstall Tool you can download. Then I installed Visual Studio 2005 Team Edition ENU. This was a trial version for 180 days.
15
2589
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 interval. Basically, I look in a SQL table (queue) to determine who needs to receive the text message then send the message to the address. Only problem is, the employee may receive up to 4 of the same messages because each thread gets the recors then sends the message. I need somehow to prevent...
0
5585
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted ******************************************************** For this teeny job, please refer to: http://feeds.reddit.com/feed/8fu/?o=25
3
1644
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 XP Home not Pro, Visual Studio 2005. Trying to learn SQL server with asp, javascript, vbsrcipt and HTML- new to this. Headbutted the wall for a few hours trying to install SQL Server properly. The long and short is no IIS with Win XP Home so doesnt seem to work properly. I did manage to...
1
3768
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 working with Login controls ASP.Configuration, I wanted to move my work and needed to place it on the server. Using VS 2005 , went to BUILD -Publish Web Site Checked the box for :: Alow this precompiled site to be updatable.
4
2222
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 working with Login controls ASP.Configuration, I wanted to move my work and needed to place it on the server. Using VS 2005 , went to BUILD -Publish Web Site Checked the box for :: Alow this precompiled site to be updatable.
0
9990
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9836
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10473
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7179
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5865
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4693
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4288
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3298
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.