Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2008 R2 Service Pack 3 (KB3045316) Will Not Install

Posted on 2016-08-12
13
Medium Priority
?
1,311 Views
Last Modified: 2016-09-12
Hello:

I have a 64-Bit Windows 7 Professional laptop with SQL Server 2008 R2 on it.  Today, I tried to install SQL Server 2008 R2 Service Pack 3 (KB3045316).  It failed, for both of my instances.

I conduct SQL updates on this laptop, regularly, and this is the first time that this has happened.  Also, I never have issues with SQL or its apps on my laptop.

Attached is the summary log file, as well as the detail log files for the two instances.

Can someone please help me determine how to successfully get this service pack installed?

Thank you!

John
Summary_USCA8N3FHBP32_20160812_06423.txt
Detail_GP10.txt
Detail_GP2010.txt
0
Comment
Question by:John Ellis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41756012
KB3045316 is NOT he SP3. That's a security patch to be installed AFTER SP3.

SQL Server 2008R2 SP3 is KB2979597 and you can download it from here.
0
 

Author Comment

by:John Ellis
ID: 41756304
Hi Vitor:

Thank you!  It's strange that Windows Update would try to install that security patch.  I would have thought that that "mechanism" would have been smart enough to know that I might not have service pack 3 on.

Again, that's very strange.

Let me try putting both on, then, and I'll let you know.

John
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41756312
Yes, I never saw Windows Update failing with hotfixes. It might being confused for something else.
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:John Ellis
ID: 41758116
Hi Vitor:

Actually, per the attachment, my SQL instance actually is on service pack 3 already.

So, is there some other way of getting KB3045316 installed, so that Windows Update doesn't prompt me for this?

Windows Update hasn't prompted me, since I entered this case.  But, every month, our company's laptops including mine are prompted to run Windows updates.  I just want to make sure that Windows does not error on this, again.

Thank you!

John
Capture2.PNG
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41769979
John, if you don't have more issues with this then you should have this question closed.
0
 

Author Comment

by:John Ellis
ID: 41773313
Hello:

As I mentioned, every month our company's laptops including mine are prompted to run Windows updates.  I want to make sure that Windows does not error on this, again.

So, there is still an issue.

Thank you!

John
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41774350
So you're waiting for September's update then.
0
 

Author Comment

by:John Ellis
ID: 41776369
Well, I just want to know if there's a way of my getting this service pack installed successfully, prior to the next  week or two, when my company has our laptops conduct Windows Updates.

John
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41776390
You told that SP3 it's already installed:
"Actually, per the attachment, my SQL instance actually is on service pack 3 already."

So, is there some other way of getting KB3045316 installed, so that Windows Update doesn't prompt me for this?
How often is your Windows Update checking for new updates?
You can also try to install it manually.
0
 

Author Comment

by:John Ellis
ID: 41785024
Hi Vitor:

The answers to your most recent questions, are below:

How often is your Windows Update checking for new updates?  Once a month.
You can also try to install it manually.  Actually, I reviewed online the version of SQL that this patch references.  When I run "select @@version" in SQL Management Studio for SQL Server 2008 R2, it shows that I'm already on this version.

I simply want to make sure that the next time Windows Updates runs on my laptop at my company, which may be as soon as later this week, the Windows Updates service doesn't given me an erroneous message saying that it could not install this patch.

Thanks!

John
0
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41785653
I simply want to make sure that the next time Windows Updates runs on my laptop at my company, which may be as soon as later this week, the Windows Updates service doesn't given me an erroneous message saying that it could not install this patch.
I would say that's the expected behavior but for you be sure of that you'll need to wait for the next update period.
0
 

Author Comment

by:John Ellis
ID: 41794222
Hello:

Last Thursday, my company's monthly Windows Updates installed successfully.

Thanks, for your help!

John
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41794281
Great to know.
That should be the expected behavior so everything ran fine.
Cheers
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question