CentOS Stream 9

SQL Server 2025 : Connect from Windows Client2026/03/17

 

It's possible to connect to SQL Server on Linux from Windows Clients.

[1]

This example is on Windows 11.
Download SQL Server Management Studio (SSMS) and install it.
⇒ https://docs.microsoft.com/ja-jp/sql/ssms/download-sql-server-management-studio-ssms

[2] After finishing installation, Run SSMS.
[3] The window is opened like follows.
Input your server name or IP address and username/password to connect. For Authentication, Select [SQL Server Authentication]. This example shows to connect with admin user [SA].
[4] If successfully passed authentication, it's possible to operate SQL Server on GUI with SSMS.
[5]
If you want to connect using a command, use the [sqlcmd] command.
[sqlcmd] is no longer included in SSMS 18, so if you want to use it, you will need to install it separately.
You can install [sqlcmd] by launching PowerShell and executing the following command.
⇒ PS> winget install sqlcmd
After installing [sqlcmd], it's also possible to connect to SQL Server on Linux.
Matched Content