SQL Server 2022 : インストール2023/12/15 |
Microsoft SQL Server 2022 をインストールします。
利用にあたり、事前にライセンス形態を熟読し、遵守ください。
利用するエディションによってはライセンスを購入する必要があります。 ⇒ https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing |
|
[1] | SQL Server 2022 のリポジトリを追加してインストールします。 インストール中に表示されるライセンス条件には [YES] を入力して進めます。 |
root@dlp:~#
wget https://packages.microsoft.com/keys/microsoft.asc -O /etc/apt/keyrings/mssql2022.key root@dlp:~# wget https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list -O /etc/apt/sources.list.d/mssql-server-2022.list root@dlp:~# wget https://packages.microsoft.com/config/ubuntu/22.04/prod.list -O /etc/apt/sources.list.d/msprod.list
root@dlp:~#
vi /etc/apt/sources.list.d/mssql-server-2022.list # 追記 deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/mssql-server-2022 jammy main
root@dlp:~#
vi /etc/apt/sources.list.d/msprod.list # 追記 deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/prod jammy mainroot@dlp:~# apt update root@dlp:~# apt -y install mssql-server mssql-tools unixodbc-dev # [Yes] で応答 +---------------------+ Configuring msodbcsql17 +---------------------+ | | | The license terms for this product can be downloaded from | | https://aka.ms/odbc17eula and found in | | /usr/share/doc/msodbcsql17/LICENSE.txt. | | | | By choosing 'Yes', you indicate that you accept the license terms. | | | | Do you accept the license terms? | | | | <Yes> <No> | | | +---------------------------------------------------------------------+ # [Yes] で応答 +---------------------+ Configuring mssql-tools +---------------------+ | | | The license terms for this product can be downloaded from | | http://go.microsoft.com/fwlink/?LinkId=746949 and found in | | /usr/share/doc/mssql-tools/LICENSE.TXT. | | | | By choosing 'Yes', you indicate that you accept the license terms. | | | | Do you accept the license terms? | | | | <Yes> <No> | | | +---------------------------------------------------------------------+ |
[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://aka.ms/useterms 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; preset:> Active: active (running) since Thu 2023-12-14 22:04:43 CST; 1s ago Docs: https://docs.microsoft.com/en-us/sql/linux Main PID: 1828 (sqlservr) Tasks: 104 Memory: 414.4M CPU: 1.759s CGroup: /system.slice/mssql-server.service +-- 1828 /opt/mssql/bin/sqlservr +-- 1844 /opt/mssql/bin/sqlservrroot@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 ------------------------------------- ##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 |
Sponsored Link |