Categories: sql-server, apache, webmin, ufw

Cannot connect to SQL Server Instance anymore after enabling UFW on Ubuntu 16.04 with webmin already installed

1 answer

I enabled UFW on a ubuntu server setup by someone else following the documentation on digitalocean. This server already had virtualmin/webmin installed.

Enabling the UFW had no effect on traffic with only OpenSSH allowed, and defaults set to incoming (deny), outgoing (allow). I was still able to visit the website even when Apache as not added to the UFW rule.

I had to reboot the server to see if the UFW will kick in, but the status of the firewall was "inactive" and now I cannot connect to the SQL Server Instance via the application or SSMS even after disabling the firewall.

The application has been down for hours, the world is on my neck and am almost at the end of my rope.

All answers to this question, which has the identifier 58336560

The best answer:

Going on guesswork here after multiple comments.

Sounds like you have updated the version of mssql-server but haven't updated the msodbcsql17 package. The latest CU needs the latest version of msodbcsql17 (unsure why, but not having it installed causes the connection failures).

Firstly update your packages:

sudo apt update 

Then install the latest version of msodbcsql17:

sudo apt install msodbcsql17

This should install version 17.4.2.1-1.

If this, for some reason fails. You could roll back the update to mssql-server:

sudo apt install mssql-server=14.0.3223.3-15 

Last questions

how do i remove the switch on my home screen?
how to edit the JS date and time to update atuomatically?
How to utilize data stored in a multidimensional array
Powermockito not mocking URL constructor in URI.toURL() method
Android Bluetooth LE Scanner only scans when phone's Location is turned on in some devices
docker wordpress container can't connect to mysql container
How can I declare a number in java that is more than 64-bits? [duplicate]
Optaplanner solutionClass entityCollectionProperty should never return null error when simple JSON object passed to controller
Anylogic, get the time a pedestrain is in a queue
How do I fix this syntax issue with my .flex file?
Optimizing query in PHP
How to find the highest number of a column and print two columns of that row in R?
Ideas on “Error: Type com.google.firebase.iid.zzav is referenced as an interface from com.google.firebase.messaging.zzd”?
JCIFS SmbFile.exists() and SmbFile.isDirectory() return false when it exists and I can listFiles()
PHP total order
Laravel booking system design
neural net - undefined column selected
How to indicate y axis does not start from 0 in ggplot?
Fragments in backStack
Spinner how to change the data