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 |
Sponsored Link |
|