<div>
<a href="https://support.microsoft.com/en-us/kb/3045316" rel="ugc">KB3045316</a> is NOT he SP3. That's a security patch to be installed AFTER SP3.<br />
<br />
SQL Server 2008R2 SP3 is KB2979597 and you can download it from <a href="https://www.microsoft.com/en-us/download/details.aspx?id=44271" rel="ugc">here</a>.
</div>


<div>
Hi Vitor:<br />
<br />
Thank you! &nbsp;It's strange that Windows Update would try to install that security patch. &nbsp;I would have thought that that &quot;mechanism&quot; would have been smart enough to know that I might not have service pack 3 on.<br />
<br />
Again, that's very strange.<br />
<br />
Let me try putting both on, then, and I'll let you know.<br />
<br />
John
</div>


<div>
Yes, I never saw Windows Update failing with hotfixes. It might being confused for something else.
</div>


<div>
Hi Vitor:<br />
<br />
Actually, per the attachment, my SQL instance actually is on service pack 3 already.<br />
<br />
So, is there some other way of getting KB3045316 installed, so that Windows Update doesn't prompt me for this?<br />
<br />
Windows Update hasn't prompted me, since I entered this case. &nbsp;But, every month, our company's laptops including mine are prompted to run Windows updates. &nbsp;I just want to make sure that Windows does not error on this, again.<br />
<br />
Thank you!<br />
<br />
John<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w34/1111760/Capture2.PNG" target="_blank" class="file-inline" title="SP3 (7 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Capture2.PNG</a>
</div>


Capture2.PNG

<div>
John, if you don't have more issues with this then you should have this question closed.
</div>


<div>
Hello:<br />
<br />
As I mentioned, every month our company's laptops including mine are prompted to run Windows updates. &nbsp;I want to make sure that Windows does not error on this, again.<br />
<br />
So, there is still an issue.<br />
<br />
Thank you!<br />
<br />
John
</div>


<div>
So you're waiting for September's update then.
</div>


<div>
Well, I just want to know if there's a way of my getting this service pack installed successfully, prior to the next &nbsp;week or two, when my company has our laptops conduct Windows Updates.<br />
<br />
John
</div>


<div>
You told that SP3 it's already installed:<br />
<i>&quot;Actually, per the attachment, my SQL instance actually is on service pack 3 already.&quot;</i><br />
<br />

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


<div>
Hi Vitor:<br />
<br />
The answers to your most recent questions, are below:<br />
<br />
How often is your Windows Update checking for new updates? &nbsp;<i>Once a month.<br />
</i>You can also try to install it manually. &nbsp;<i>Actually, I reviewed online the version of SQL that this patch references. &nbsp;When I run &quot;select @@version&quot; in SQL Management Studio for SQL Server 2008 R2, it shows that I'm already on this version.<br />
</i><br />
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.<br />
<br />
Thanks!<br />
<br />
John
</div>


<div>
Hello:<br />
<br />
Last Thursday, my company's monthly Windows Updates installed successfully.<br />
<br />
Thanks, for your help!<br />
<br />
John
</div>


<div>
Great to know.<br />
That should be the expected behavior so everything ran fine.<br />
Cheers
</div>


<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
I have a 64-Bit Windows 7 Professional laptop with SQL Server 2008 R2 on it. &nbsp;Today, I tried to install SQL Server 2008 R2 Service Pack 3 (KB3045316). &nbsp;It failed, for both of my instances.<br />
<br />
I conduct SQL updates on this laptop, regularly, and this is the first time that this has happened. &nbsp;Also, I never have issues with SQL or its apps on my laptop.<br />
<br />
Attached is the summary log file, as well as the detail log files for the two instances.<br />
<br />
Can someone please help me determine how to successfully get this service pack installed?<br />
<br />
Thank you!<br />
<br />
John<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111286/Summary_USCA8N3FHBP32_20160812_06423.txt" target="_blank" class="file-inline" title="Summary (7 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Summary_USCA8N3FHBP32_20160812_06423.txt</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111287/Detail_GP10.txt" target="_blank" class="file-inline" title="Detail_GP10 (946 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Detail_GP10.txt</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111288/Detail_GP2010.txt" target="_blank" class="file-inline" title="Detail_GP2010 (946 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Detail_GP2010.txt</a>
</div>
</div>


Detail_GP10.txt

Summary_USCA8N3FHBP32_20160812_06423.txt

Detail_GP2010.txt

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

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.