HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Connect to SQL Server on Linux over the network

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
theconnectsqlnetworklinuxserverover

Problem

I have setup Microsoft SQL Server on an Ubuntu VM.

I know how to connect to SQL Server on Windows using SSMS -> but unfortunately I can not install SSMS on Ubuntu.

Which leads me to the question at hand of how would I do this from the terminal using sqlcommand?

Solution

1st you need to identify your VM IP address, supposing it is 10.1.1.10

sqlcmd -S 10.1.1.10 -U SA -P "YourPassword"


Either check connectivity between your host and your VM using

ping 10.1.1.10


and/or

telnet 10.1.1.10 1433


Read detailed instructions on Microsoft's link below:

sqlcmd on Linux

Regarding to web connection, there's no guarantee to be able to connect to the VM via web, that imply many aspects.

Code Snippets

sqlcmd -S 10.1.1.10 -U SA -P "YourPassword"
ping 10.1.1.10
telnet 10.1.1.10 1433

Context

StackExchange Database Administrators Q#207210, answer score: 2

Revisions (0)

No revisions yet.