Tuesday, April 26, 2016

SQL Server Windows Core installation does not support Reporting Service

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:
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 parameterFeature parameterDescriptionWindows Core Support
SQL
Installs the SQL Server Database Engine, Replication, Fulltext, and Data Quality Server.YES
SQLSQLEngineInstalls just the SQL Server Database Engine.YES
SQLReplicationInstalls the Replication component along with SQL Server Database Engine.YES
SQLFullTextInstalls the FullText component along with SQL Server Database Engine.YES
SQLDQCopies 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
SQLPolyBaseInstalls 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
ToolsBCInstalls backward compatibility components.NO
ToolsBOLInstalls SQL Server Books Online components to view and manage help content.NO
ToolsConnInstalls connectivity components.YES
ToolsSSMSInstalls 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 providerNO
ToolsADV_SSMSInstalls 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 AdvisorNO
ToolsDREPLAY_CTLRInstalls Distributed Replay controllerYES
ToolsDREPLAY_CLTInstalls Distributed Replay clientYES
ToolsSNAC_SDKInstalls SDK for Microsoft SQL Server Native ClientYES
ToolsSDKInstalls the software development kit.NO
ToolsLocalDBInstalls LocalDB, an execution mode of SQL Server Express targeted to program developers. LocalDB is an option when installing any SKU of SQL Server 2016 ExpressYES

1 comment: