I've completely gone past all install errors, figured I'd share the solution:
1. Make sure you DB has collation set to "SQL_Latin_General_Cp1_CI_AS
That will solve the case sensitive issue with the tables/columns
2. Go through the sql files in the dataprovider folder to do a search and replace on all parameters that have mismatched case. The files that had mismatched case in params I found were
Schema
04.04.01
04.05.00
04.06.00
04.07.00
I found all of the errors by running the "Auto" installtion the other installs didn't seem to be providing the necessary logs. Once the auto installation ran, I wrote down which files failed, looked up their logs in the data providers and read the erros, it will tell you very plainly which parameters need to be fixed. Once you fix them in the sql files delete you db and redo the install.