patternsqlMinor
Connect to SQL Server on Linux over the network
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?
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
Either check connectivity between your host and your VM using
and/or
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.
sqlcmd -S 10.1.1.10 -U SA -P "YourPassword"Either check connectivity between your host and your VM using
ping 10.1.1.10and/or
telnet 10.1.1.10 1433Read 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.10telnet 10.1.1.10 1433Context
StackExchange Database Administrators Q#207210, answer score: 2
Revisions (0)
No revisions yet.