Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
live
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

sql-docs/docs/database-engine/install-windows/install-sql-server-on-server-core.md

Go to file
 
 
Cannot retrieve contributors at this time
Install SQL Server on Server Core Prerequisites Supported Features Supported scenarios Upgrade Install Feature parameters Installation options Configure remote access of [!INCLUDEssNoVersion] on Server Core Enable remote connections on the instance of [!INCLUDEssNoVersion] Enable and start the [!INCLUDEssNoVersion] browser service Create exceptions in Windows Firewall Enable TCP/IP on the instance of [!INCLUDEssNoVersion] Uninstall Start a new command prompt See also
328 lines (215 sloc) 20.8 KB
Raw Blame
Open in GitHub Desktop
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom monikerRange
Install SQL Server on Server Core
You can install SQL Server on a Server Core installation. The Server Core installation option provides a minimal environment for running specific server roles.
rwestMSFT
randolphwest
09/16/2021
sql
install
conceptual
intro-installation
>=sql-server-2016

Install SQL Server on Server Core

[!INCLUDE SQL Server -Windows Only]

You can install [!INCLUDEssNoVersion] on a Server Core installation.

The Server Core installation option provides a minimal environment for running specific server roles. This helps to reduce maintenance and management requirements and the attack surface for those server roles.

For a list of currently supported operating systems, see Hardware and Software Requirements for Installing SQL Server.

Prerequisites

Requirement How to install
[!INCLUDEdnprdnshort] 4.6.1 For all editions of [!INCLUDEssnoversion] except [!INCLUDEssExpress], Setup requires the [!INCLUDEdnprdnshort] 4.6.1 Server Core Profile. SQL Server Setup will automatically install this if it is not already installed. Installation requires a reboot. You can install [!INCLUDEdnprdnshort] before you run setup to avoid a reboot.
Windows Installer 4.5 Shipped with Server Core installation.
Windows PowerShell Shipped with Server Core installation.
Java Runtime In order to use PolyBase, you need to install the appropriate Java Runtime. For more information, see PolyBase installation.

Supported Features

Use the following table to find which features are supported in [!INCLUDEssnoversion] on a Server Core installation .

Feature Supported Additional Information
[!INCLUDEssDE] Services Yes
[!INCLUDEssNoVersion] Replication Yes
Full Text Search Yes
[!INCLUDEssASnoversion] Yes
[!INCLUDErsql_productname_md] Yes
[!INCLUDEssRSnoversion] No
[!INCLUDEssNoVersion] Data Tools (SSDT) No
Client Tools Connectivity Yes
Integration Services Server Yes
Client Tools Backward Compatibility No
Client Tools SDK No
[!INCLUDEssNoVersion] Books Online No
Management Tools - Basic Remote Only Installation of these features on Server Core is not supported. These components can be installed on a different server that is not Server Core and connected to the [!INCLUDEssDE] services installed on Server Core.
Management Tools - Complete Remote Only Installation of these features on Server Core is not supported. These components can be installed on a different server that is not Server Core and connected to the [!INCLUDEssDE] services installed on Server Core.
Distributed Replay Controller No
Distributed Replay Client Remote Only Installation of these features on Server Core is not supported. These components can be installed on a different server that is not Server Core , and connected to the [!INCLUDEssDE] services installed on Server Core.
SQL Client Connectivity SDK Yes
Microsoft Sync Framework Yes Microsoft Sync Framework is not included in the [!INCLUDEssnoversion] installation package. You can download the appropriate version of Sync Framework from this Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkId=221788) page and install it on a computer that is running Server Core.
[!INCLUDEssMDSshort] No
[!INCLUDEssDQSnoversion] No

Supported scenarios

The following table shows the supported scenario matrix for installing [!INCLUDEssnoversion] on a Server Core.

Installation Valid target
[!INCLUDEssNoVersion] editions All [!INCLUDEssnoversion] 64-bit editions
[!INCLUDEssNoVersion] language All languages
[!INCLUDEssNoVersion] language on OS language/locale (combination) ENG [!INCLUDEssNoVersion] on JPN (Japanese) Windows

ENG [!INCLUDEssNoVersion] on GER (German) Windows

ENG [!INCLUDEssNoVersion] on CHS (Chinese-China) Windows

ENG [!INCLUDEssNoVersion] on ARA (Arabic (SA)) Windows

ENG [!INCLUDEssNoVersion] on THA (Thai) Windows

ENG [!INCLUDEssNoVersion] on TRK (Turkish) Windows

ENG [!INCLUDEssNoVersion] on pt-PT (Portuguese Portugal) Windows

ENG [!INCLUDEssNoVersion] on ENG (English) Windows
Windows edition Windows Server 2022 Datacenter

Windows Server 2022 Datacenter: Azure edition

Windows Server 2022 Standard

Windows Server 2019 Datacenter

Windows Server 2019 Standard

[!INCLUDEwinserver2016_datacenter_md]

[!INCLUDEwinserver2016_standard_md]

Upgrade

On Server Core installations, upgrading from [!INCLUDEssSQL14] to [!INCLUDEsssql16-md] is supported.

Install

[!INCLUDEssnoversion] does not support setup by using the installation wizard on the Server Core operating system. When installing on Server Core, [!INCLUDEssNoVersion] Setup supports full quiet mode by using the /Q parameter, or Quiet Simple mode by using the /QS parameter. For more information, see Install SQL Server from the Command Prompt.

Regardless of the installation method, you are required to confirm acceptance of the software license terms as an individual or on behalf of an entity, unless your use of the software is governed by a separate agreement such as a [!INCLUDEmsCoName] volume licensing agreement or a third-party agreement with an ISV or OEM.

The license terms are displayed for review and acceptance in the Setup user interface. Unattended installations (using the /Q or /QS parameters) must include the /IACCEPTSQLSERVERLICENSETERMS parameter. You can review the license terms separately at Microsoft Software License Terms.

[!INCLUDE sql-eula-link]

[!NOTE]
Depending on how you received the software (for example, through [!INCLUDEmsCoName] volume licensing), your use of the software may be subject to additional terms and conditions.

To install specific features, use the /FEATURES parameter and specify the parent feature or feature values. For more information about feature parameters and their use, see the following sections.

Feature parameters

Feature parameter Description
SQLENGINE Installs only the [!INCLUDEssDE].
REPLICATION Installs the Replication component along with [!INCLUDEssDE].
FULLTEXT Installs the FullText component along with [!INCLUDEssDE].
AS Installs all [!INCLUDEssASnoversion] components.
IS Installs all [!INCLUDEssISnoversion] components.
CONN Installs the connectivity components.
ADVANCEDANALYTICS Installs R Services, requires the database engine. Unattended installations require /IACCEPTROPENLICENSETERMS parameter.

See the following examples of the usage of feature parameters:

Parameter and values Description
/FEATURES=SQLEngine Installs only the [!INCLUDEssDE].
/FEATURES=SQLEngine,FullText Installs the [!INCLUDEssDE] and full-text.
/FEATURES=SQLEngine,Conn Installs the [!INCLUDEssDE] and the connectivity components.
/FEATURES=SQLEngine,AS,IS,Conn Installs the [!INCLUDEssDE], [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and the connectivity components.
/FEATURES=SQLENGINE,ADVANCEDANALYTICS /IACCEPTROPENLICENSETERMS Installs the [!INCLUDEssDE] and [!INCLUDErsql_productname_md].

Installation options

The Setup supports the following installation options while installing [!INCLUDEssnoversion] on a Server Core operating system:

  1. Installation from Command Line

    To install specific features using the command prompt installation option, use the /FEATURES parameter and specify the parent feature or feature values. The following is an example of using the parameters from the command line:

    Setup.exe /qs /ACTION=Install /FEATURES=SQLEngine,Replication /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS

  2. Installation using Configuration File

    Setup supports the use of the configuration file only through the command prompt. The configuration file is a text file with the basic structure of a parameter (name/value pair) and a descriptive comment. The configuration file specified at the command prompt should have an .INI file name extension. See the following examples of ConfigurationFile.INI:

    • Installing [!INCLUDEssDE].

    The following example shows how to install a new stand-alone instance that includes [!INCLUDEssNoVersion] [!INCLUDEssDE]:

    ; SQL Server Configuration File  
[OPTIONS]  

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   

ACTION="Install"  

; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   

FEATURES=SQLENGINE  

; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the ssNoVersion Database Engine, and Analysis Services (AS).  

INSTANCENAME="MSSQLSERVER"  

; Specify the Instance ID for the ssNoVersion features you have specified. ssNoVersion directory structure, registry structure, and service names will incorporate the instance ID of the ssNoVersion instance.   

INSTANCEID="MSSQLSERVER"  

; Account for ssNoVersion service: Domain\User or system account.   

SQLSVCACCOUNT="NT Service\MSSQLSERVER"  

; Windows account(s) to provision as ssNoVersion system administrators.   

SQLSYSADMINACCOUNTS="\<DomainName\UserName>"  

; Accept the License agreement to continue with Installation  

IAcceptSQLServerLicenseTerms="True"

    • Installing connectivity components. The following example shows how to install the connectivity components:

      ; SQL Server Configuration File  
[OPTIONS]  

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   

ACTION="Install"  

; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   

FEATURES=Conn  

; Specifies acceptance of License Terms  

IAcceptSQLServerLicenseTerms="True

    • Installing all supported features

      The following example shows how to install all supported features of [!INCLUDEssnoversion] on Server Core:

      ; SQL Server Configuration File  
[OPTIONS]  
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.   

ACTION="Install"  

; Specifies features to install, uninstall, or upgrade. The lists of features include SQLEngine, FullText, Replication, AS, IS, and Conn.   

FEATURES=SQLENGINE,FullText,Replication,AS,IS,Conn  

; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the ssNoVersion Database Engine (SQL), or Analysis Services (AS).  

INSTANCENAME="MSSQLSERVER"  

; Specify the Instance ID for the ssNoVersion features you have specified. ssNoVersion directory structure, registry structure, and service names will incorporate the instance ID of the ssNoVersion instance.   

INSTANCEID="MSSQLSERVER"  

; Account for ssNoVersion service: Domain\User or system account.   

SQLSVCACCOUNT="NT Service\MSSQLSERVER"  

; Windows account(s) to provision as ssNoVersion system administrators.   

SQLSYSADMINACCOUNTS="\<DomainName\UserName>"  

; The name of the account that the Analysis Services service runs under.   

ASSVCACCOUNT= "NT Service\MSSQLServerOLAPService"  

; Specifies the list of administrator accounts that need to be provisioned.   

ASSYSADMINACCOUNTS="\<DomainName\UserName>"  

; Specifies the server mode of the Analysis Services instance. Valid values are MULTIDIMENSIONAL, POWERPIVOT or TABULAR. ASSERVERMODE is case-sensitive. All values must be expressed in upper case.   

ASSERVERMODE="MULTIDIMENSIONAL"  

; Optional value, which specifies the state of the TCP protocol for the ssNoVersion service. Supported values are: 0 to disable the TCP protocol, and 1 to enable the TCP protocol.  

TCPENABLED=1  

;Specifies acceptance of License Terms  

IAcceptSQLServerLicenseTerms="True"

    The following shows how you can launch Setup using a custom or default configuration file:

    • Launch setup using a custom configuration file:

      To specify the configuration file at the command prompt:

      Setup.exe /QS /ConfigurationFile=MyConfigurationFile.INI

      To specify passwords at the command prompt instead of in the configuration file:

      Setup.exe /QS /SQLSVCPASSWORD="************" /ASSVCPASSWORD="************"  /ConfigurationFile=MyConfigurationFile.INI

    • Launch setup using DefaultSetup.ini:

      If you have the DefaultSetup.ini file in the \x86 and \x64 folders at the root level of the [!INCLUDEssNoVersion] source media, open the DefaultSetup.ini file, and then add the Features parameter to the file.

      If the DefaultSetup.ini file does not exist, you can create it and copy it to the \x86 and \x64 folders at the root level of the [!INCLUDEssNoVersion] source media.

Configure remote access of [!INCLUDEssNoVersion] on Server Core

Perform the actions described below to configure remote access of a [!INCLUDEssnoversion] instance that is running on Server Core.

Enable remote connections on the instance of [!INCLUDEssNoVersion]

To enable remote connections, use SQLCMD.exe locally and execute the following statements against the Server Core instance:

EXEC sys.sp_configure N'remote access', N'1'  
GO
RECONFIGURE WITH OVERRIDE
GO

Enable and start the [!INCLUDEssNoVersion] browser service

By default, the Browser service is disabled. If it is disabled on an instance of [!INCLUDEssNoVersion] running on Server Core, run the following command from the command prompt to enable it:

Set-service sqlbrowser -StartupType Auto

After it is enabled, run the following command from the command prompt to start the service:

Start-service sqlbrowser

Create exceptions in Windows Firewall

To create exceptions for [!INCLUDEssNoVersion] access in Windows Firewall, follow the steps specified in Configure the Windows Firewall to Allow SQL Server Access.

Enable TCP/IP on the instance of [!INCLUDEssNoVersion]

The TCP/IP protocol can be enabled through Windows PowerShell for an instance of [!INCLUDEssNoVersion] on Server Core. Follow these steps:

  1. In PowerShell: Import-Module SQLPS.

  2. In the Microsoft [!INCLUDEssNoVersion] Powershell window, run the following script to enable the TCP/IP protocol:

$smo = 'Microsoft.SqlServer.Management.Smo.'  
$wmi = new-object ($smo + 'Wmi.ManagedComputer')  
# Enable the TCP protocol on the default instance.  If the instance is named, replace MSSQLSERVER with the instance name in the following line.  
$uri = "ManagedComputer[@Name='" + (get-item env:\computername).Value + "']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"  
$Tcp = $wmi.GetSmoObject($uri)  
$Tcp.IsEnabled = $true  
$Tcp.Alter()  
$Tcp

Uninstall

After you log on to a computer that is running Server Core, you have a limited desktop environment with an Administrator command prompt. You can use this command prompt to launch the uninstall an of [!INCLUDEssnoversion]. To uninstall an instance of [!INCLUDEssnoversion], launch the uninstallation from the command prompt in full quiet mode by using the /Q parameter, or quiet simple mode by using the /QS parameter. The /QS parameter shows progress through the UI, but does not accept any input. /Q runs in a quiet mode without any user interface.

To uninstall an existing instance of [!INCLUDEssNoVersion]:

Setup.exe /Q /Action=Uninstall /FEATURES=SQLEngine,AS,IS /INSTANCENAME=MSSQLSERVER

To remove a named instance, specify the name of the instance instead of MSSQLSERVER in the preceding example.

Start a new command prompt

If you accidentally close the command prompt, you can start a new command prompt by following these steps:

  1. Press Ctrl+Shift+Esc to display Task Manager.
  2. On the Applications tab, click New Task.
  3. In the Create New Task dialog box, type cmd in the Open field and then select OK.

See also

Install SQL Server Using a Configuration File
Install SQL Server from the Command Prompt
Editions and supported features of SQL Server 2017
Install Server Core
Configure a Server Core installation of Windows Server 2016 with Sconfig.cmd
Failover Cluster Cmdlets in Windows PowerShell