you have sqlserver 2014 "Business Intelligence" Edition
its server+cals only.
Find SqlServer Edition like enterprise/Deveoper
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 83%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MichaelWorkingDowntown
21
Reputation points
I want to find out if a server is enterprise/developer etc. So far this is all I can get.
select @@version
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Jun 17 2016 19:14:09 Copyright (c) Microsoft Corporation Business Intelligence Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
select SERVERPROPERTY('Edition') AS Edition
12. 0.5000.0
SQL Server | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 27,096 Reputation points2022-12-29T18:20:44.74+00:00 - Are you on prem. or in the cloud?
- What is wrong with the 'Business Intelligence Edition'?
-
MichaelWorkingDowntown 21 Reputation points
2022-12-29T18:52:20.52+00:00 Perm
How many cores/sockets do you get with Business Intelligence Edition -
Erland Sommarskog 131.4K Reputation points MVP Volunteer Moderator2022-12-29T22:08:05.927+00:00 By they way, you are on SP2. The last Service Pack for SQL 2014 is SP3. You should install SP3 first possible occasion for this server. Then you could apply CU4 which is the last Cumulative Update for SQL 2014. Windows Update will then offer you the latest GDR with security fixes. You should absolutely not be pn SP2.
As for Business Intelligence Edition this existed for a while, SQL 2012 and SQL 2014, I think, but it has gone out of fashion since.
Sign in to comment
Answer accepted by question author
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 82,326 Reputation points Volunteer Moderator2022-12-29T18:53:51.757+00:00