Linux:ways connnection

Following are some ways to connect to sql server on linux from windows and linux:

Ways Of Connecting To Sql Server On Linux, Putty, Ssms, Or Sqlcmd Tool

Prerequisites:

--ipaddress of linux system

--active sql server services

Modes of connection:

--Existing linux machine with sqlcmd tools

--using putty from windows machine

--using SSMS from windows

Check SQL server services:

#systemctl status mssql-server

#get ip address

#ifconfig

Install sqlcmd SQL Server command-line tools on Linux

To know more about SQLCMD tool, here you go and here:

To use sqlcmd tool you need to install package:

Use this link to get the required package, choose the latest version.

Open the terminal and locate to downloads directory:

Install the package:

#rpm-ivh mssqltools

If you get any dependencies error when installing package go here

After installationAdd /opt/mssql-tools/bin/ to your PATH environment variable in a bash shell.

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bashrc

Check if SQLCMD is installed or not:

Run sqlcmd with parameters for your SQL Server name (-S), the user name (-U), and the password (-P). In this tutorial, you are connecting locally, so the server name is localhost. The user name is SA and the password is the one you provided for the SA account during setup.