January 17, 2018 at 1:48 pm
Hello,
I just installed CU9 for sql2014 on top of SP2. I rebooted and I see in the installed programs that CU9 was installed, but when I run select @@version I do not see the CU9 was updated. All I see is SP2.
Any ideas what's is going on here? Appreciate it.
January 17, 2018 at 1:56 pm
JP10 - Wednesday, January 17, 2018 1:48 PMHello,
I just installed CU9 for sql2014 on top of SP2. I rebooted and I see in the installed programs that CU9 was installed, but when I run select @@version I do not see the CU9 was updated. All I see is SP2.
Any ideas what's is going on here? Appreciate it.
Try this (Taken from Glenn Berry's 'SQL Server 2014 Diagnostic Information Queries')
SELECT
SERVERPROPERTY('ServerName') AS [ServerName],
SERVERPROPERTY('InstanceName') AS [Instance],
SERVERPROPERTY('IsClustered') AS [IsClustered],
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [NetBIOS],
SERVERPROPERTY('Edition') AS [Edition],
SERVERPROPERTY('ProductLevel') AS [ProductLevel],
SERVERPROPERTY('ProductUpdateLevel') AS [UpdateLevel],
SERVERPROPERTY('ProductVersion') AS [Version],
SERVERPROPERTY('ProductMajorVersion') AS [MajorVersion],
SERVERPROPERTY('ProductMinorVersion') AS [MinorVersion],
SERVERPROPERTY('ProductBuild') AS [Build],
SERVERPROPERTY('ProductBuildType') AS [BuildType],
SERVERPROPERTY('ProductUpdateReference') AS [UpdateReference],
SERVERPROPERTY('ProcessID') AS [ProcessID],
SERVERPROPERTY('Collation') AS [Collation],
SERVERPROPERTY('InstanceDefaultDataPath') AS [DataPath],
SERVERPROPERTY('InstanceDefaultLogPath') AS [LogPath],
SERVERPROPERTY('BuildClrVersion') AS [BuildCLRVersion]
January 17, 2018 at 1:57 pm
JP10 - Wednesday, January 17, 2018 1:48 PMHello,
I just installed CU9 for sql2014 on top of SP2. I rebooted and I see in the installed programs that CU9 was installed, but when I run select @@version I do not see the CU9 was updated. All I see is SP2.
Any ideas what's is going on here? Appreciate it.
Hi!
Sorry, I currently have not the same Version on that level, but have you queried the other properties, to check if it is visible there?
SELECT
SERVERPROPERTY('MachineName') AS ComputerName,
SERVERPROPERTY('ServerName') AS InstanceName,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EngineEdition') AS EngineEdition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel,
SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference,
SERVERPROPERTY('ProductBuild') AS ProductBuild,
SERVERPROPERTY('ProductBuildType') AS ProductBuildType,
@@VERSION AS Version
C.-A.
January 17, 2018 at 2:00 pm
Yes tried those server properties. The UpdateLevel is null. It should say CU9.
January 17, 2018 at 2:02 pm
JP10 - Wednesday, January 17, 2018 2:00 PMYes tried those server properties. The UpdateLevel is null. It should say CU9.
Are you sure you are running the query against the correct sql instance?
January 17, 2018 at 2:02 pm
JP10 - Wednesday, January 17, 2018 1:48 PMHello,
I just installed CU9 for sql2014 on top of SP2. I rebooted and I see in the installed programs that CU9 was installed, but when I run select @@version I do not see the CU9 was updated. All I see is SP2.
Any ideas what's is going on here? Appreciate it.
Can you publish the exact results of your query?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 17, 2018 at 2:03 pm
yes there is only 1 default instance. Here is the result from my @@version
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (Intel X86)
Jun 17 2016 19:21:56
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
January 17, 2018 at 2:09 pm
This is the result of select @@version on my laptop:
Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64) Oct 5 2016 19:04:21 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Makes me wonder if CU9 is actually included in SP2. I will have to check.
January 17, 2018 at 2:10 pm
I think it has something to do with the Installer? As I'm trying to now install CU10 I see in the "Select Features" section under Instances all I see is Shared Features\SQL Client Connectivity SDK. I don't see any of the "Database engine" or other features.
January 17, 2018 at 2:14 pm
Lynn Pettis - Wednesday, January 17, 2018 2:09 PMThis is the result of select @@version on my laptop:
Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64) Oct 5 2016 19:04:21 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)Makes me wonder if CU9 is actually included in SP2. I will have to check.
It's included. I just upgraded 3 other dev boxes and it shows CU9. It's just this dev box that is having issues.
January 17, 2018 at 2:42 pm
That's what I got from one of my recently patched servers.
Microsoft SQL Server 2014 (SP2-CU9) (KB4055557) - 12.0.5563.0 (X64) Dec 7 2017 01:00:06 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 17, 2018 at 3:04 pm
I downloaded SP2 and the latest CU and applied them. This is what I get now:
Microsoft SQL Server 2014 (SP2-CU10-GDR) (KB4052725) - 12.0.5571.0 (X64) Jan 10 2018 15:52:08 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
January 17, 2018 at 3:05 pm
Dumb question, did you restart the system?
January 17, 2018 at 3:06 pm
Lynn Pettis - Wednesday, January 17, 2018 3:05 PMDumb question, did you restart the system?
yes
January 17, 2018 at 3:10 pm
Okay, I got nothing.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply