Ubuntu 20.04
Sponsored Link

SQL Server 2022 : インストール2023/01/27

 
Microsoft SQL Server 2022 をインストールします。
利用にあたり、事前にライセンス形態を熟読し、遵守ください。
利用するエディションによってはライセンスを購入する必要があります。
⇒ https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing
[1] SQL Server 2022 のリポジトリを追加してインストールします。
インストール中に表示されるライセンス条件には [YES] を入力して進めます。
root@dlp:~#
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

root@dlp:~#
curl https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list | tee /etc/apt/sources.list.d/mssql-server-2022.list

root@dlp:~#
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | tee /etc/apt/sources.list.d/msprod.list
root@dlp:~#
apt update

root@dlp:~#
apt -y install mssql-server mssql-tools unixodbc-dev
[2] SQL Server の初期セットアップです。
root@dlp:~#
/opt/mssql/bin/mssql-conf setup

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID) - CPU core utilization restricted to 20 physical/40 hyperthreaded
  7) Enterprise Core (PAID) - CPU core utilization up to Operating System Maximum
  8) I bought a license through a retail sales channel and have a product key to enter.
  9) Standard (Billed through Azure) - Use pay-as-you-go billing through Azure.
 10) Enterprise Core (Billed through Azure) - Use pay-as-you-go billing through Azure.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.
By choosing an edition billed Pay-As-You-Go through Azure, you are verifying
that the server and SQL Server will be connected to Azure by installing the
management agent and Azure extension for SQL Server.

# 利用するエディションを選択
Enter your edition(1-10): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

# ライセンス条項に同意
Do you accept the license terms? [Yes/No]:Yes

# 管理者パスワードを設定
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...

ForceFlush is enabled for this instance.
ForceFlush feature is enabled for log durability.
Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

root@dlp:~#
systemctl status mssql-server

*  mssql-server.service - Microsoft SQL Server Database Engine
     Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor >
     Active: active (running) since Fri 2023-01-27 01:44:54 UTC; 1min 13s ago
       Docs: https://docs.microsoft.com/en-us/sql/linux
   Main PID: 6206 (sqlservr)
      Tasks: 171
     Memory: 662.0M
     CGroup: /system.slice/mssql-server.service
             +--6206 /opt/mssql/bin/sqlservr
             +--6255 /opt/mssql/bin/sqlservr

root@dlp:~#
echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh

root@dlp:~#
source /etc/profile.d/mssql.sh

[3] 管理ユーザーで SQL Server へ接続して動作確認します。
root@dlp:~#
sqlcmd -S localhost -U SA

Password:  
# 初期セットアップで設定した管理者パスワード


# システムデータベース表示
1> select name,database_id from sys.databases; 
2> go 
name                 database_id
-------------------- -----------
master                         1
tempdb                         2
model                          3
msdb                           4

(4 rows affected)

# システムユーザー表示
1> select name from sysusers; 
2> go 
name
-------------------------------------
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
dbo
guest
INFORMATION_SCHEMA
public
sys

(16 rows affected)

# 現在のユーザー表示
1> select current_user; 
2> go 

---------------------------------------
dbo

(1 rows affected)

# 終了
1> exit 
関連コンテンツ