For security reasons I have to deploy Web API on a Linux Server. As well as the backend database SQL Server should be deployed within Linux environment. please help if anyone knows about it.
For Microsoft SQL Server deployment on Linux, is on beta testing at the moment. so not really recommended for production.
For the time being you'll have to use MySQL + PHP or keep using Windows Server.
Since SQL Server is not fully functional in Linux yet. You can connect to your backend SQL Server through an intermediate Linux Server API in between, something like this: