SQL Server 2022 : Connect from Windows Client2023/11/24 |
|
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/en-us/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] | After successfully passed authentication, it's possible to operate SQL Server on GUI with SSMS. |
|
|
| [5] |
For [sqlcmd] command, it is not included in SSMS 18 and later, so it needs to install manually if you need. Download it from the link below.
After installing [sqlcmd], it's also possible to connect to SQL Server on Linux.
⇒ https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility |
|
Matched Content