I discussed in one of my previous articles how you could connect SQL Server on Linux using command utilities tool. A lot of SQL DBAs are not very comfortable with the command line utility tool. They want to connect SQL Linux Instance using SQL Server Management Studio because it gives them better flexibility.
In this blog, we will see how you can connect your SQL Server Linux Instance via management studio.
Follow the below steps to connect SQL Server Linux Instance using SSMS
- Check the IP of your Linux machine
Syntax: ifconfig
- Open the SQL Server Management Studio (SSMS), key the IP your Linux machine, SQL user account & password and click on “Connect”
- Verify the SQL Server Instance is running on which operating system
Hope, it was a very useful post and saved your time too!
4 thoughts on “Connect SQL Server Linux Instance using SSMS”
Hi Dharmendra ,
I am happy to your blog which helping to understand the New SQL server 2016 version installation and other activity in SQL server in Ubuntu box. Could you please let me know how to open the SSMS using command because I am not able find the options .
Hi Pavan,
I am happy you liked my blogs. If you want to open SSMS on Linux box, it won’t open as it only available for Windows not for Linux. You have to open SSMS on a windows machine and connect your Linux SQL Server Instance using IP or hostname.
On the Linux machine, you can connect SQL Server using sqlcmd tool which I talked about here – http://www.dharmendrakeshari.com/sql-server-linux-installation-part4-install-sql-server-tools-ubuntu/
Thank you for this very nice set of blog postings. It will be worth it to try the mssql extention for Visual Studio Code which is a GUI based sql tool on Linux, Mac and Windows. https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql
And this is the getting started guide FYI. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-develop-use-vscode
Thanks Eric for your valuable feedback!