Ok for those who are struggling with this problem I figured out the solution.

php_pdo_mssql.dll is no longer supported. If you wish to connect to MS Sql Server on a windows server the recommended is to use phpodbc. ADODB is pretty solid choice IMO.