Troubleshoot configuration problem on Ubuntu 20.04 VPS - installing Microsoft SQL Server on VPS.
Budget: $30 – $250 USD
I’m trying to setup Microsoft SQL server on an Ubuntu 20.04 linux VPS, so that a Microsoft SQL database can be hosted there. The database files are on the VPS already in /home/FSData/.
I’ve followed instructions here: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15 , down to where it says “Connect locally”. When I try to run this command, I get an error: command not found:
sqlcmd -S localhost -U SA -P '<YourPassword>'
The SQL server password is: Ftz3Wcs2!
port 1433 is open on the firewall.
I’m starting to wonder if I did the whole setup as the wrong user. I have a “Dawn” user for me to use instead of “root”.
After solving the issue above and going through the rest of the instructions, I’ll need to do these things, Use SQL Server Management Studio on Windows to manage SQL Server on Linux
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-manage-ssms?view=sql-server-ver15
from my windows laptop. If you can get the above errors corrected, that is mostly what I need you to do. I can do the Windows part of the setup.
I’ve followed instructions here: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15 , down to where it says “Connect locally”. When I try to run this command, I get an error: command not found:
sqlcmd -S localhost -U SA -P '<YourPassword>'
The SQL server password is: Ftz3Wcs2!
port 1433 is open on the firewall.
I’m starting to wonder if I did the whole setup as the wrong user. I have a “Dawn” user for me to use instead of “root”.
After solving the issue above and going through the rest of the instructions, I’ll need to do these things, Use SQL Server Management Studio on Windows to manage SQL Server on Linux
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-manage-ssms?view=sql-server-ver15
from my windows laptop. If you can get the above errors corrected, that is mostly what I need you to do. I can do the Windows part of the setup.