once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server on Linux to SSMS on you local system, in my case it is windows Pro 10.
I have installed SSMS from Microsoft site.
without installing SSMS if you want to connect to SQL Command port you have to go to
find SQLCMD location (/opt/mssql-tools/bin) and run the command
we have to install it like here
I have observed that SQL Server installation is simple but once it is install i was having issues/problem to connect to sqlcmd
i was getting error as server not found
shows Port as 0.0.0.0:1433 -localhost
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : : Error Locating Server/Instance Specified [xFFFFFFFF]. . Sqlcmd:
Microsoft ODBC Driver 13 for SQL Server
you can get this network information as
docker inspect <container_ID>
This solved my problem
once that is done, you can able to connect to SQLCMD
SQLCMD -S localhost,1433 -U “SA” -P”Pa@@word123″
or using SSMS