Recently I had this error in my Spring Boot application,  during the connection to MSSQL Server:

ERROR org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl - Could not fetch the SequenceInformation from the database Invalid object name 'INFORMATION_SCHEMA.SEQUENCES'.
    at ~[sqljdbc4-4.0.jar:?]
    at ~[sqljdbc4-4.0.jar:?]
    at ~[sqljdbc4-4.0.jar:?]

After the investigation, I discovered that I had two issues in my configuration that caused this behavior.

My previous configuration in the was:


What I found out is that I'm setting the wrong property, the right one should be:

I also used this query to check the version of my SQL Server, and it turned out that I'm connecting to version 2008 instead of 2012. So, in the end, my connection dialect property was:

After I changed this, everything worked like a charm.

Pin It