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

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
John EllisAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
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
John EllisAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, I never saw Windows Update failing with hotfixes. It might being confused for something else.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

John EllisAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
John, if you don't have more issues with this then you should have this question closed.
0
John EllisAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
So you're waiting for September's update then.
0
John EllisAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
John EllisAuthor Commented:
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John EllisAuthor Commented:
Hello:

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

Thanks, for your help!

John
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Great to know.
That should be the expected behavior so everything ran fine.
Cheers
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.