MSSQL Setup Issues

Razuna v2 Legacy Self-Hosted
1

Hi,

I’m getting errors when trying to connect Razuna to our MSSQL database and am at a loss for what to try next…? Otherwise Razuna is working great!

I’m able to install/restore the H2 database ok.

I set up MSSQL as outlined here: Setup MSSQL Server for Razuna

From the new install screen, I selected Custom Install -> MSSQL. After entering my db info, clicking Check Connection returns: "We could successfully connect to your database. Please continue. "

On the next screen, trying either the Continue with New Data, or Restore from Backup, fails to complete.

There’s an SQL error in /rtelogs: Invalid object name 'options'. being called by settings.cfc.

Checking inside MSSQL, no tables are being created…

The Verified Datasources in the OpenDB Admin are: h2 (H2), mssql (jTDS), razuna_backup (H2), razuna_client (MySQL), razuna_default (H2)

Any ideas what to try/look for next?

Win 2012
MSSQL 2012 Express
Tomcat 8 (xms 1024m, xmx 4096m, xss 1024k)
Razuna 1.7.5

Much appreciated,
David

2

Ok, got it to work…

Started with a fresh instance of Razuna and selected MSSQL right off. All good.

However, trying to switch back to H2 doesn’t work, (error: The datasource h2 could not be found or was invalid.) I seem to think now I was seeing that same error last night for MSSQL, and created the (above post) MSSQL datasource in OpenBD after reading something in the wee hours.

Perhaps there’s some complication when switching from one DB type to another after the initial install? Doesn’t seem like the Datasource and subsequent DB tables/etc are being created.

Easy enough work around…

Thanks for the project!
David