NO SQL Server, stay with PostGresSQL database
I also decided not move ahead with SQL Server as well due to uncessary complexities to set up a connection from Matlab. As a result, the notes and caveats are below but I am sticking with PostGreSQL for now as it is very easy to work with and multi platform. It is open source as well which means it is FREE.
For JDBC connection:
My Notes and caveats:
Try opening the SQL server configuration manager with RUN AS ADMIN option and see if that makes any differencofe
Add in the C:\Users\Bryan\AppData\Roaming\MathWorks\MATLAB\R2014a\javalibrarypath.txt contains something like:
The javaclasspath.txt has
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc.jar
I had to correct:
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc4.jar
If you the JDBC 4.1, you will get error of
3:01:30 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>
SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Use the JDBC4.0 not 4.1!
I created Data Source to SQL Server with sample sa credentials for SQL Server authentication