Previous topic: Seven obstacles of SQL Server Core Installation
Read next:
- How to Install and prepare Windows Core for SQL Server installation
- Five Steps of Remote SQL Server installation using PowerShell
Yep.
You could guess that it is pretty obvious that under Windows Core you can't have SQL Server Management Studio or Profiler, but we wouldn't imagine that one of four main SQL Server components won't be available in Core.
I've tried to install SSRS on my Virtual Core machine and here is what I've got:
Will copy-paste the error message here:
The following error occurred:
You have selected a feature that is not supported on Windows Server Core.
The supported features on Windows Server Core are:
Database Engine Services,
SQL Server Replication,
Full-Text and Semantic Extractions for Search,
Analysis Services,
Client Tools Connectivity,
Integration Services,
and SQL Client Connectivity SDK.
That Error message let you figure out what you CAN'T install on Windows Core.
To make that decision you have to look through the whole list of possible options in MSDN: https://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature
Obviously, SSRS is a component, but it is not in the "safe core" list.
Lets look at everything else with little cheating: By my experience I can do an installation of whole "SQL" feature module, that means, PolyBase ss part of "SQL" parent feature also has to be installable.
Hold on, lets look at my prior post: Installing Polybase for SQL Server 2016
Basically, for installing "PolyBase" feature you have to install Java from Oracle.
So, I've tried to install PolyBase and I've got that error:
That was predictable.
Then I've tried to install Java driver and got following:
In other words: my device is not in the list of those 3 billions devices, which run Java.
That means, technically, installation of PolyBase is allowed, but not possible on Windows Core Server.
So, where is PolyBase when you install "SQL" feature? - It is just ignored.
I've checked it by running following command:
In order to determine what is supported and what is not supported by Core installation I had to run each feature separately and here is the result table. Enjoy.
Read next:
- How to Install and prepare Windows Core for SQL Server installation
- Five Steps of Remote SQL Server installation using PowerShell
Yep.
You could guess that it is pretty obvious that under Windows Core you can't have SQL Server Management Studio or Profiler, but we wouldn't imagine that one of four main SQL Server components won't be available in Core.
I've tried to install SSRS on my Virtual Core machine and here is what I've got:
Will copy-paste the error message here:
The following error occurred:
You have selected a feature that is not supported on Windows Server Core.
The supported features on Windows Server Core are:
Database Engine Services,
SQL Server Replication,
Full-Text and Semantic Extractions for Search,
Analysis Services,
Client Tools Connectivity,
Integration Services,
and SQL Client Connectivity SDK.
That Error message let you figure out what you CAN'T install on Windows Core.
To make that decision you have to look through the whole list of possible options in MSDN: https://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature
Obviously, SSRS is a component, but it is not in the "safe core" list.
Lets look at everything else with little cheating: By my experience I can do an installation of whole "SQL" feature module, that means, PolyBase ss part of "SQL" parent feature also has to be installable.
Hold on, lets look at my prior post: Installing Polybase for SQL Server 2016
Basically, for installing "PolyBase" feature you have to install Java from Oracle.
So, I've tried to install PolyBase and I've got that error:
That was predictable.
Then I've tried to install Java driver and got following:
That means, technically, installation of PolyBase is allowed, but not possible on Windows Core Server.
So, where is PolyBase when you install "SQL" feature? - It is just ignored.
I've checked it by running following command:
SELECT SERVERPROPERTY ('IsPolybaseInstalled') AS IsPolybaseInstalled;
That command will return "0" (Zero), which means, feature is not enabled.In order to determine what is supported and what is not supported by Core installation I had to run each feature separately and here is the result table. Enjoy.
| Parent feature parameter | Feature parameter | Description | Windows Core Support |
|---|---|---|---|
| SQL | Installs the SQL Server Database Engine, Replication, Fulltext, and Data Quality Server. | YES | |
| SQL | SQLEngine | Installs just the SQL Server Database Engine. | YES |
| SQL | Replication | Installs the Replication component along with SQL Server Database Engine. | YES |
| SQL | FullText | Installs the FullText component along with SQL Server Database Engine. | YES |
| SQL | DQ | Copies the files required for completing the Data Quality Server installation. After completing SQL Server installation, you must run the DQSInstaller.exe file to complete the Data Quality Server installation. For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation. This also installs SQL Server Database Engine. | YES |
| SQL | PolyBase | Installs PolyBase components. | NO |
| AS | Installs all Analysis Services components. | YES | |
| RS | Installs all Reporting Services components. | NO | |
| DQC | Installs Data Quality Client. | NO | |
| IS | Installs all Integration Services components. | YES | |
| MDS | Installs Master Data Services. | NO | |
| Tools | Installs client tools and SQL Server Books Online components. | NO | |
| Tools | BC | Installs backward compatibility components. | NO |
| Tools | BOL | Installs SQL Server Books Online components to view and manage help content. | NO |
| Tools | Conn | Installs connectivity components. | YES |
| Tools | SSMS | Installs SQL Server Management Tools – Basic. This includes the following: - SQL Server Management Studio support for the SQL Server Database Engine, SQL Server Express, sqlcmd utility, and the SQL Server PowerShell provider | NO |
| Tools | ADV_SSMS | Installs SQL Server Management Tools – Complete. This includes the following components in addition to the components in the Basic version: - SQL Server Management Studio support for Reporting Services, Analysis Services, and Integration Services - SQL Server Profiler - Database Engine Tuning Advisor | NO |
| Tools | DREPLAY_CTLR | Installs Distributed Replay controller | YES |
| Tools | DREPLAY_CLT | Installs Distributed Replay client | YES |
| Tools | SNAC_SDK | Installs SDK for Microsoft SQL Server Native Client | YES |
| Tools | SDK | Installs the software development kit. | NO |
| Tools | LocalDB | Installs LocalDB, an execution mode of SQL Server Express targeted to program developers. LocalDB is an option when installing any SKU of SQL Server 2016 Express | YES |
thank you so much. saved my bacon today.
ReplyDelete