SQL SP2 KB Update failing on SQL SP3 server

Hi

We have a SQL server that was upgraded to SP3 at some point (not sure that that update was smooth...but I wasn't involved with that). WSUS is now saying that KB3045313, which is a Security Update for SQL Server 2008 R2 Service Pack 2, is needed on my SQL server running SP3.
I don't know what to do to either get this update installed or get WSUS to realize that the update isn't needed. I am hoping that I don't have to back out SP3 to then apply the SP2 update? Any advice is greatly appreciated.
Thanks Amy
SBSIAdminAsked:
Who is Participating?
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.

ste5anSenior DeveloperCommented:
How many instances do you have on your machine? Maybe there are more than one running on it..
0
SBSIAdminAuthor Commented:
This particular SQL server only has one instance installed.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I am hoping that I don't have to back out SP3 to then apply the SP2 update?
No need to. This securiy update (July 2015) is more recent than SP3 (September 2014) so should be installed after SP3. You can proceed with no worries.

After you installing it the SELECT @@VERSION command should return 10.50.6220
10.50.6000 is the version number for SP3.

Cheers.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

SBSIAdminAuthor Commented:
Vitor,
Knowing the update is needed for a SP3 install is good. I am still in a situation, it won't install.
As that SQL server stands now, when I run the above command, I get SQl 2008 (R2) - 10.50.4033.0 (X64)...this makes me believe SP3 didn't install correctly.
When I view Programs and features, the version for SQL shows 10.53.6000.34 (for the setup program item).
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you running the command in the correct SQL Server instance?
0
SBSIAdminAuthor Commented:
There is only one SQL instance on this server.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check in the SQL Configuration Manager. Also double check if you're not connected to a remote instance instead of the local one.
Can you post here a screenshot of the Program and Features, showing the SQL Server version?
0
SBSIAdminAuthor Commented:
I know I am logging onto a local instance and the only instance on the server.

Not sure what you are looking for in SQL Configuration Manager...other to verify there is only one instance, I will post pics in attachment.
SQL-Server-KB-Issue.pdf
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just want to confirm. 4 eyes see better than 2 ;)
Anyway, you shouldn't check the version in Setup but 64-bit, that's what is installed. So you'll need to install the SP3 before proceed with the security patch.
0
ste5anSenior DeveloperCommented:
Seems what ever was done, SP3 for SQL Server 2008 R2 was not installed. So WSUS is right with that patch for SP2.

See also Microsoft SQL Server Builds

It's a upgrade patch to 10.50.4042.
0
SBSIAdminAuthor Commented:
Is there a recommendation from anyone that I should try installing SP3 again?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You have all evidences that says SP3 isn't installed. Don't know what you need more.
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
ste5anSenior DeveloperCommented:
When there are no objections to do it.. Ask the guys who work with the server. Under normal circumstances I would do it.
0
SBSIAdminAuthor Commented:
I am the "guys" that work the server...but not an expert on SQL :)
I will give installing/reinstalling SP3 a shot...
0
ste5anSenior DeveloperCommented:
With "these guys" I mean those who wrote the applications and code for it.
0
SBSIAdminAuthor Commented:
Installed SP3, Installed Updates and all seems good. Thanks for the advice.
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

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.