Unattended installation of SQL Server 2017 on Linux

You can perform an unattended installation by following these steps:

Add the database and install SQL Server.

When you run mssql-conf setup, set the environment variable and use the-n option (not prompted).

#! / bin/bash-e # Use the following variables to control your install:# Password for the SA user (required) MSSQL_SA_PASSWORD=''# Product ID of the version of SQL server you're installing# Must be evaluation, developer, express, web, standard, enterprise Or your 25 digit product key# Defaults to developerMSSQL_PID='evaluation'# Install SQL Server Agent (recommended) SQL_INSTALL_AGENT='y'# Install SQL Server Full Text Search (optional) # SQL_INSTALL_FULLTEXT='y'# Create an additional user with sysadmin privileges (optional) # SQL_INSTALL_USER=''# SQL_INSTALL_USER_PASSWORD=''if [- z $MSSQL_SA_PASSWORD] then echo Environment variable MSSQL_SA_PASSWORD must be set for unattended install exit 1fiecho Adding Microsoft repositories...sudo curl-o / etc/ Yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.reposudo curl-o / etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repoecho Installing SQL Server...sudo yum install-y mssql-serverecho Running mssql-conf setup...sudo MSSQL_SA_PASSWORD=$MSSQL_SA_PASSWORD\ MSSQL_PID=$MSSQL_PID\ / opt/mssql/bin/mssql -conf-n setup accept-eulaecho Installing mssql-tools and unixODBC developer...sudo ACCEPT_EULA=Y yum install-y mssql-tools unixODBC-devel# Add SQL Server tools to the path by default:echo Adding SQL Server tools to your path...echo PATH= "$PATH:/opt/mssql-tools/bin" > > ~ / .bash_profileecho 'export PATH= "$PATH:/opt/mssql-tools/bin" > > ~ / .bashrc # Optional SQL Server Agent installation:if [!-z $SQL_INSTALL_AGENT] then echo Installing SQL Server Agent... Sudo yum install-y mssql-server-agentfi# Optional SQL Server Full Text Search installation:if [!-z $SQL_INSTALL_FULLTEXT] then echo Installing SQL Server Full-Text Search... Sudo yum install-y mssql-server-ftsfi# Configure firewall to allow TCP port 1433:echo Configuring firewall to allow traffic on port 1433...sudo firewall-cmd-zone=public-add-port=1433/tcp-permanentsudo firewall-cmd-reload# Example of setting post-installation configuration options# Set trace flags 1204 and 1222 for deadlock tracing:#echo Setting trace flags...#sudo / opt/mssql/bin/mssql-conf traceflag 1204 1222 on# Restart SQL Server after making configuration changes:echo Restarting SQL Server...sudo systemctl restart mssql-server # Connect to server and get the version:counter=1errstatus=1while [$counter-le 5] & & [$errstatus=1] do echo Waiting for SQL Server to start... Sleep 5s / opt/mssql-tools/bin/sqlcmd\-S localhost\-U SA\-P $MSSQL_SA_PASSWORD\-Q "SELECT @ @ VERSION" 2 > / dev/null errstatus=$? ((counter++)) done# Display error if connection failed:if [$errstatus = 1] then echo Cannot connect to SQL Server Installation aborted exit $errstatusfi# Optional new user creation:if [!-z $SQL_INSTALL_USER] & & [!-z $SQL_INSTALL_USER_PASSWORD] then echo Creating user $SQL_INSTALL_USER / opt/mssql-tools/bin/sqlcmd\-S localhost\-U SA\-P $MSSQL_SA_PASSWORD\-Q "CREATE LOGIN [$SQL_INSTALL_USER] WITH PASSWORD=N'$SQL_INSTALL_USER_PASSWORD', DEFAULT_DATABASE= [master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON ALTER SERVER ROLE [sysadmin] ADD MEMBER [$SQL_INSTALL_USER] "fiecho Done!

Run the unattended installation script:

1. Save the above script as install_sql.sh.

two。 Specify MSSQL_SA_PASSWORD, MSSQL_PID, and other variables you want to modify.

3. Modify the script to be executable.

Chmod + x install_sql.sh

4. Run the script.

. / install_sql.sh