SQL Server 2017 on Linux自动安装

古城堡

#!/bin/bash　　# Use the following variables to control your install:
　　# Password for the SA user (required)
　　MSSQL_SA_PASSWORD=''

　　# Product>　　# Must be evaluation, developer, express, web, standard, enterprise, or your 25 digit product key
　　# Defaults to developer
　　MSSQL_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 1
　　fi
　　echo Adding Microsoft repositories...
　　sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
　　sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo
　　echo Installing SQL Server...
　　sudo yum install -y mssql-server
　　echo Running mssql-conf setup...
　　sudo MSSQL_SA_PASSWORD=$MSSQL_SA_PASSWORD \
　　MSSQL_PID=$MSSQL_PID \
　　/opt/mssql/bin/mssql-conf -n setup accept-eula
　　echo 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_profile
　　echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
　　source ~/.bashrc
　　# Optional SQL Server Agent installation:
　　if [ ! -z $SQL_INSTALL_AGENT ]
　　then
　　echo Installing SQL Server Agent...
　　sudo yum install -y mssql-server-agent
　　fi
　　# 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-fts
　　fi
　　# 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 --permanent
　　sudo 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=1
　　errstatus=1
　　while [ $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 $errstatus
　　fi
　　# 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;>　　fi
　　echo Done!