Hi guys, we are having some issues connecting to an ms sql server database for Opinio. When using the default internal database Opinio webpage can be accessed and seems fully operational.But when we try to use the MS SQL database we get the following error when connecting to the webpage (see attachment1).
Using the database_sqlServer.properties file we have entered the correct server, port, db name, user name, and password, and then renamed this file as database.properties (see database.properties as attachment2).
we have test connected to the SQL database opinio with the opinio username and password and this connected correctly and has fulldbo rights.
When creating the opinio database we ran the sqlserver_create.sql script which executed without errors.