The full Java stack error of the database connection problem is probably recorded inside knowage.log. Have a look here.
Also, i end up to setup the database connection always with JNDI contexts instead of direct JDBC, because, aditional parameters may be required (for example oracle.jdbc.timezoneAsRegion=false for my Oracle database). Maybe there is a similar requirement for MSSQL databases.