I installed 2 VM`s on Virtualbox.
One is an Ubuntu 16.04 machine on which I succesfully installed MSSQL server 2019.
I can connect to the sql server from the localhost using hostname and 127.0.0.1
when I check the status I get this
lodi@xubuntu-virtual-db:/opt/mssql$ systemctl status mssql-server
â— mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: active (running) since Mi 2020-05-27 14:36:46 CEST; 1h 26min ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 717 (sqlservr)
CGroup: /system.slice/mssql-server.service
├─717 /opt/mssql/bin/sqlservr
└─903 /opt/mssql/bin/sqlservr
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [122B blob data]
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [100B blob data]
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [79B blob data]
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [71B blob data]
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [168B blob data]
Mai 27 14:37:21 xubuntu-virtual-db sqlservr[717]: [124B blob data]
Mai 27 14:42:23 xubuntu-virtual-db sqlservr[717]: [205B blob data]
Mai 27 14:42:23 xubuntu-virtual-db sqlservr[717]: [156B blob data]
Mai 27 14:42:23 xubuntu-virtual-db sqlservr[717]: [244B blob data]
Mai 27 14:42:23 xubuntu-virtual-db sqlservr[717]: [195B blob data]
the other is a win 2016 server on which I installed SQL server management studio. When I try to connect from the win 2016 server using sql management studio over TCP/IP, the connection fails with the message that the host refused
the connection.
When I try to use mssql-conf to set the TCP port I get the following message
lodi@xubuntu-virtual-db:/opt/mssql/bin$ sudo ./mssql-conf set tcpport 1433
Die Einstellung "tcpport" wird nicht unterstützt.
I chose the developer version of sql server, to test settings on.
any tips?
