Exception occurred checking user login : java.sql.SQLException: 'UCASE' is not a recognised function name.

This error is an indication of an incorrect setting in the file ApplicationSettings.properties, located in [tomcat]/webapps/asset-bank/WEB-INF/classes. The setting sql-generator-class must read as follows:

sql-generator-class=com.bright.assetbank.database.SQLServerGenerator

You need to restart Tomcat to pick up this change.