r/SQLServer•
Kynaeus

Question about a version mismatch btwn Config Manager and Management Studio

Hey folks, I feel like this is a dumb question but I'm hoping someone can shine a little light on this

My goal is to patch this SQL version up to a minimum where TLS1.2 support is added, which is a PCI DSS v3.2 goal

My problem is that Config Manager's properties sheet for this database instance shows the version as 10.53.6000.34. Following the update center I downloaded KB4057113 as that's the newest patch available for SQL Server 2008 r2 SP3, which is the version I'm running

The 64-bit patch doesn't let you select components to update with a note that "[Error Message] There are no SQL Server instances or shared features that can be updated on this computer"

I ran the 32-bit patch and it installed some 'support files' and nothing else before closing itself. When I check versions in Config Manager it is no different, but when I run the 64-bit patch it lists the installed SQL instances and components and clearly lists my patch level as 10.53.6560.0 - Programs and Features' Installed Updates corroborates that I do indeed have Hotfix 6560 for SQL Server 2008r2 (KB 4057113) installed and queries return the same version so my question is did I miss patching something, is there something about Config Manager that I don't know to explain why the versions listed are different?

Version numbers can be translated from here

The SQL update studio shows the newest service pack, cumulative update, or general distribution release for each version

Posted May 22, 2018, 8:22 PM UTC · edited

32
TequilaCamper•

Just do "select @@version " or the ServerProperties query you showed in the screen shot - you are at 6560. The configuration manager thing is interesting, on the random SQL2012 server i just checked its at 11.0.6260, but in Config manager it shows as 11.3.6020.0. The help in Cm says "Version Displays the version number of this instance of SQL Server" - but clearly thats not the same. There is no 10.53.x version of SQL 2008 R2 anyway that i've ever seen - they are just 10.50.x

1
KynaeusOP•

If you check out the version numbers from this link you can see there is an "or version 10.53..." note under SQL 2008r2 sp3, from what I've seen so far SQL Express instances on that version have the 10.53.x notation so I'm assuming 10.50.x is for the standard one?

I'll check out the other query you mentioned too, thanks for your time!

1