Is it possible to access a Windows MSSQL server from an instance of Linux?

All we need is an easy explanation of the problem, so here it is.

I’m trying to assess the viability of using Linux within a very-much Windows environment for bash/scripting utilities to be performed. From the documentation I could find, ubuntu access is possible but it seems to be from where the SQL DB is installed in Linux, rather than in Windows. Are there any hoops to jump through to setup this access via Linux or Windows-Subsystem-Linux?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

If you are asking if you can connect to a SQL server (running on windows) from a Linux server, then yes you can…

SQL will respond to port 1433 (if you didn’t change the default) and does not care the OS behind.

Same is true the other way around as well… if you run SSMS from windows and try to connect to a linux SQL Server, it will work too

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply