SQL Server 2025 : インストール2026/03/06

# 変更
deb [arch=amd64,arm64,armhf signed-by=/etc/apt/keyrings/microsoft.asc] https://packages.microsoft.com/ubuntu/24.04/mssql-server-2025 noble main

# 変更
deb [arch=amd64,arm64,armhf signed-by=/etc/apt/keyrings/microsoft.asc] https://packages.microsoft.com/ubuntu/24.04/prod noble main

# [Yes] で応答
    +---------------------+ Configuring msodbcsql18 +---------------------+
    |                                                                     |
    | The license terms for this product can be downloaded from           |
    | https://aka.ms/odbc18eula and found in                              |
    | /usr/share/doc/msodbcsql18/LICENSE.txt.                             |
    |                                                                     |
    | By choosing 'Yes', you indicate that you accept the license terms.  |
    |                                                                     |
    | Do you accept the license terms?                                    |
    |                                                                     |
    |                  <Yes>                     <No>                     |
    |                                                                     |
    +---------------------------------------------------------------------+

# [Yes] で応答
    +--------------------+ Configuring mssql-tools18 +--------------------+
    |                                                                     |
    | The license terms for this product can be downloaded from           |
    | http://go.microsoft.com/fwlink/?LinkId=2320959 and found in         |
    | /usr/share/doc/mssql-tools18/LICENSE.TXT.                           |
    |                                                                     |
    | By choosing 'Yes', you indicate that you accept the license terms.  |
    |                                                                     |
    | Do you accept the license terms?                                    |
    |                                                                     |
    |                  <Yes>                     <No>                     |
    |                                                                     |
    +---------------------------------------------------------------------+

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Enterprise Developer (free, no production use rights)
  3) Standard Developer (free, no production use rights)
  4) Express (free)
  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

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

# ライセンス条項に同意
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...

.....
.....

Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

● mssql-server.service - Microsoft SQL Server Database Engine
     Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; pre>
     Active: active (running) since Fri 2026-03-06 00:19:55 UTC; 56s ago
       Docs: https://docs.microsoft.com/en-us/sql/linux
   Main PID: 2008 (sqlservr)
      Tasks: 96
     Memory: 560.4M (peak: 561.0M)
        CPU: 5.607s
     CGroup: /system.slice/mssql-server.service
             +-- 2008 /opt/mssql/bin/sqlservr
             +-- 2050 /opt/mssql/bin/sqlservr

# システムデータベース表示
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