I think the difficulty here is finding Linux libraries that will connect to MS SQL Server. Pretty sure that is why Linux AR to a MS SQL DB (which traditionally had to be in Windows) has never been supported (of course now that there is SQL Server for Linux things may change at some point). As for the web tier, a Linux web server will be fine with either Linux or Windows AR Servers.